Registered aircraft · 40,473

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N5585FSouth Texas Air Force LLC · Mission, TXBuilt 1968 · S/N 28-24918 N5585PBas Part Sales LLC · Greeley, COBuilt 1958 · S/N 24-649 N5585QCoxwell James · Midlothian, TXBuilt 1965 · S/N 2981 N5585WFoss Jason Steven · Cokato, MNBuilt 1962 · S/N 28-665 N5586USoisson Douglas M · Barnesville, GABuilt 1969 · S/N 28-26316 N55870Legacy Aviation LLC · Tea, SDS/N 28-7305487 N55871Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1959 · S/N 18-6409 N55879Buchholtz Tony E · Greenville, OHBuilt 1973 · S/N 28-7325485 N55880Wings Up LLC · Saint Augustine, FLBuilt 1973 · S/N 28-7325517 N55881Phoenix Kingdom LLC · Washington, DCS/N 28-7325518 N5588FRckr Aviation LLC · Chehalis, WABuilt 1968 · S/N 28-24921 N5588UMontgomery Richard E · Omaha, NEBuilt 1969 · S/N 28-26318 N5588WBartz Nicole · Cleveland, MOBuilt 1962 · S/N 28-725 N55890S & L Sports LLC · New Hampton, IABuilt 1973 · S/N 28-7305492 N55899Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1973 · S/N 28-7325521 N5589FTjl Aviation LLC · Atlanta, GABuilt 1968 · S/N 28-24922 N5589UGq Aviation LLC · Cherry Hill, NJBuilt 1969 · S/N 28-26320 N558AZHess Michael R · Alexandria, VAFirst renewal noticeBuilt 2004 · S/N 90399 N558FLRoyal Greene Holdings LLC · Spout Spring, VABuilt 1971 · S/N 28-7125399 N558JRichley Robert C · Lees Summit, MOBuilt 1985 · S/N 706 N558RBNash Garrett J · Bliss, IDBuilt 1997 · S/N 22833 N558SHAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 2004 · S/N 3582 N558SMTsvang Volodymyr · Redondo Beach, CABuilt 1975 · S/N 28-7505130 N558TLLally Timothy A · Bell Gardens, CABuilt 1989 · S/N 1838L N55905Top Coat Takeoff LLC · Cincinnati, OHBuilt 1973 · S/N 28-7305496 N5590FLee A Archer Jr Red Tail Youth Flying Progrom Inc · New Windsor, NYS/N 28-24923 N55913Buckner Business Services Inc · Trenton, MOBuilt 1973 · S/N 28-7305497 N55915Loncella James G · Johnstown, PABuilt 1973 · S/N 28-7305500 N5591WMontag Mark W · Pine River, WIBuilt 1962 · S/N 28-794 N55920Gillbreath Monty Everett · Livingston, TXS/N 28-7325529 N55925Goodwin Collin H · Hobbs, NMS/N 28-7325532 N5592FEagle Air Flying Club Inc · Bowling Green, OHBuilt 1968 · S/N 28-24879 N5592QGrant Charles A Jr · Denton, TXBuilt 1965 · S/N 2986 N5592VBlack Dog Air LLC · Satellite Beach, FLBuilt 1977 · S/N 28-7790482 N55930Lafrance Troy R · Paola, KSBuilt 1973 · S/N 28-7325534 N55933Knoxville Aviation · Knoxville, IAS/N 28-7305504 N55934Roloff Paul E Trustee · Waupaca, WIBuilt 1973 · S/N 28-7305505 N55938Turner Cole M · Round Rock, TXBuilt 1973 · S/N 287325536 N5593QBrazdys Luke V · Kingman, AZBuilt 1965 · S/N 2987 N55940Zadrick Wayne J · Bristol, CTBuilt 1973 · S/N 28-7325537 N55942Ray Lynn M · Cloquet, MNBuilt 1973 · S/N 28-7325538 N5594PBombo Aviation LLC · Gold Beach, ORBuilt 1959 · S/N 24-661 N55954Registration Pending · Jacksonville, FLRegistration pendingBuilt 1973 · S/N 28-7325539 N55955Pierce Riley Deirdre · Chicago, ILBuilt 1973 · S/N 28-7325542 N5595EV & E Sunset LLC · St George, UTBuilt 1978 · S/N 17271897 N5595FByrne Matthew A · West Allis, WIBuilt 1968 · S/N 28-24883 N5595PCassell Joseph · Singer, LABuilt 1959 · S/N 24-662 N5595QLivezey Patrick · Lithia, FLBuilt 1965 · S/N 2988 N55967Hisman Gary L · Skagway, AKS/N 28-7305511 N55968Tindle David W · Fennville, MIFirst renewal noticeS/N JC-1

Back to AD 80-04-03 R2