Registered aircraft · 68,375

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.

N312AVAshley Dallas · Cardiff By The Sea, CABuilt 1968 · S/N 680049 N312BJMcneilus Grant · Dodge Center, MNBuilt 2019 · S/N CC19-0049 N312BWGiacinto Lucci A Jr · Nashville, MIBuilt 1962 · S/N SP-44 N312CADunn Jonathan · Murfreesboro, TNBuilt 1968 · S/N 28R-30590 N312CMChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-103 N312ESGolden Age N312es LLC · Norwalk, IABuilt 2022 · S/N 2881587 N312FMBosch Jay E · Atwater, MNBuilt 2013 · S/N 82162 N312JMMiller James D · Sun Prairie, WIBuilt 2004 · S/N 81175 N312LLNilsen Christopher · Livermore, CABuilt 1964 · S/N 194 N312PDValdosta Flying Service Inc · Valdosta, GABuilt 2000 · S/N 172S8408 N312PZMatrix Commerce Solutions LLC · Pt Pleas Bch, NJS/N 92252 N312RBBarcelona Russell J · Buffalo, NYBuilt 2024 · S/N MK-0077 N312RHOstendorf Mark W · Santa Barbara, CABuilt 1986 · S/N 1898 N312SLKeith Shon D · Flandreau, SDBuilt 2013 · S/N 82645 N312SMShelbyville Flight Academy LLC · Smyrna, TNBuilt 1977 · S/N 17270091 N312TMoore Joseph A · Kingwood, WVBuilt 1953 · S/N 18-2426 N312TATaylor Charles E · Glen Ellyn, ILBuilt 1979 · S/N 17273565 N312TDAircom Nwa LLC · Siloam Springs, ARBuilt 1976 · S/N 17266129 N312TMVan Hofwegen Douglas E · Spencer, IABuilt 1973 · S/N 28-7305382 N312TSWoodford John E · Madison, WIBuilt 1998 · S/N 408-98 N3130MCarlblom Boyd W · Eveleth, MNBuilt 1947 · S/N 12-1818 N3130RN738yc LLC · Fresno, CABuilt 1969 · S/N 28R-31115 N3131CBell Anthony Scott · Garland, TXBuilt 2008 · S/N 6-5847 N3131TSilver Express Co Db · Miami, FLBuilt 2004 · S/N 2844107 N3131ZPralle Jeffory K · Wasilla, AKBuilt 1959 · S/N 22-7076 N3132PSarratt Curtis H · Annapolis, MDBuilt 1957 · S/N 23-1056 N3132TUballe Ruben · Axtell, TXBuilt 1967 · S/N 17700432 N3133PLumley John J · Delray Beach, FLFirst renewal noticeBuilt 1957 · S/N 23-1057 N3133QLearn 2 Fly Ct LLC · Simsbury, CTBuilt 1977 · S/N 28-7716138 N3133TGiddy Up Aviation LLC · Ada, OKBuilt 1967 · S/N 17700433 N3134MDrummond Dana S · Anchorage, AKBuilt 1947 · S/N 12-1830 N3134PSchmidt Casey D · Cedar Rapids, IAS/N 23-1059 N3134WDans Flying Service Inc · Crookston, MNS/N 19027C N3135EHerring Christopher E · Granbury, TXBuilt 1978 · S/N 17271447 N3135GDrake Michael L · Bellevue, WABuilt 1995 · S/N 20513 N3135MWilson Brian W · Palmer, AKS/N 12-1829 N3135RSerna Alvaro V · San Antonio, TXBuilt 1969 · S/N 28R-31117 N31369Walburn John M · Mansfield, OHBuilt 1940 · S/N LB10480 N3136MEms Ronald D · Portland, ORBuilt 1947 · S/N 12-1808 N3136ZSchafer Patrick A · Marietta, OHBuilt 1959 · S/N 22-7080 N3137ERegistered aircraftBuilt 1978 · S/N 17271448 N31381Strobridge Mark D · Bunnell, FLBuilt 1982 · S/N 15285644 N31382Davis Ted E · Brodhead, WIBuilt 1940 · S/N L8060T N31385Registration Pending · Missoula, MTRegistration pendingBuilt 1978 · S/N 28-7816554 N3138MSpoden Thomas R · Maple Lake, MNBuilt 1947 · S/N 12-1821 N3138TJones Daniel D · Ekron, KYBuilt 1968 · S/N 17700438 N31399G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7816556 N313ACAero Craft Of Bloomington LLC · Bloomington, ILBuilt 1977 · S/N 28-7816013 N313BLDaggett Keith W · Rockport, MEBuilt 1976 · S/N 17267097 N313CEAvidash LLC · Cape Coral, FLBuilt 1972 · S/N 886-72

Back to AD 90-04-06 R1