Registered aircraft · 68,369

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N243JWUhles Denny · Bakersfield, CABuilt 1983 · S/N 243 N243KJeffryes Richard B · Creswell, ORFirst renewal noticeBuilt 1946 · S/N 7AC 2710 N243MAJ W Peterson Inc · Warren, MNBuilt 2003 · S/N 479-2003 N243MDWhiteis Barnabas G · Apex, NCBuilt 1997 · S/N 20665 N243MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881708 N243RVDippel James W · Chandler, TXBuilt 2015 · S/N 11467 N243SMc Gavock Edward · Columbus, WIBuilt 1961 · S/N 1 N243SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1961 · S/N 22-8376 N243SPBarbers Point Flight School LLC · Kapolei, HIBuilt 1999 · S/N 172S8212 N243SWWells Paul L · Whitefish, MTFirst renewal noticeBuilt 1999 · S/N 001SW N243THillestad Darrell · Aberdeen, SDBuilt 1953 · S/N 18-2357 N243WMoore William · Dalhart, TXBuilt 1971 · S/N 17260205 N243XWilliamson Lee E · Franklin, KYS/N 160 N243XJLoiacono Vincent · Sunfield, MIBuilt 1965 · S/N 28-2095 N244004 One Air LLC · Holland, MIBuilt 1977 · S/N 15280253 N24403Somboonsap Patanapong · Oakland Park, FLBuilt 1977 · S/N 15280254 N24406Mcguire Brandon C · Erick, OKS/N 1742 N24407Wolstenholme Ralph E · Westfield, PABuilt 1941 · S/N 1743 N2440CHeaton Thomas Caleb · Princeton, KYS/N 38-79A0187 N2440DXing Kong Aviation Service LLC · Atwater, CAS/N 4496305 N2440TEngler William O · Filion, MIBuilt 1978 · S/N 38-78A0803 N2441AKnowles Warren R · Ocean City, NJBuilt 1978 · S/N 38-78A0691 N2441EMyf Holdings LLC · San Diego, CABuilt 2000 · S/N 17280879 N24426Podeweltz Dana A · Merrill, WIBuilt 1940 · S/N 1762 N2442EExecutive Flyers Inc · Sacramento, CABuilt 1978 · S/N 17271285 N2442FZeien Robert A · Charlton, MAS/N 38-79A0444 N2442MRegistration Pending · Sterling, AKRegistration pendingBuilt 1947 · S/N 12-1545 N24430Pryce James T · Ebensburg, PABuilt 1940 · S/N 1766 N24434Mountain Top Aviation Inc · Ebensburg, PAS/N 1771 N2443AGauthier Evans J · Mckinney, TXBuilt 1953 · S/N 22-1096 N2443FAnywhere Atp LLC · Mt Juliet, TNBuilt 1979 · S/N 38-79A0445 N24444Kusch Kim G · Hot Springs, SDBuilt 1940 · S/N 1781 N2444AHoward Nathan L · Fairbanks, AKBuilt 1952 · S/N 18-1939 N2444HChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280874 N2444JDavis Bret R · Boynton Beach, FLBuilt 1979 · S/N 18-7909124 N2444MMerillat Anthony J · Adrian, MIBuilt 1947 · S/N 12-1682 N2444PMcgowan Robert A · Burgaw, NCS/N 22-2815 N24450Haley David A · Whitethorn, CABuilt 2004 · S/N 001 N2445AMcmillian Dean R · Wasilla, AKBuilt 1952 · S/N 18-1940 N2445DN5511f LLC · Voorhees, NJBuilt 1978 · S/N 38-79A0319 N2445PBolivar Flyers Inc · Brighton, MOBuilt 1955 · S/N 22-2816 N2445TBurwell Jacqueline D · Potwin, KSBuilt 1978 · S/N 38-78A0804 N24465Bluhm J Lawrence · Aurora, COBuilt 1940 · S/N 1802 N2446MCondor Aviation LLC · Bethlehem, PABuilt 1947 · S/N 12-1672 N2446NPilot'S Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1979 · S/N 38-79A0847 N2446VLipscomb Rik · Wichita Falls, TXFirst renewal noticeBuilt 1983 · S/N 14795330 N24472Payne Richard L · Flint Hill, VABuilt 1977 · S/N 15280272 N24477Novotny Randy · New Castle, PABuilt 1979 · S/N 38-79A1125 N2447ADyer Clifton R · Richland, WABuilt 2004 · S/N 70966 N2447BSilver Express Co · Miami, FLBuilt 1999 · S/N 17280801

Back to AD 90-04-06 R1