Skip to content

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.

N4914FCb N4914f LLC · Coventry, CTBuilt 1976 · S/N 28-7715080 N4914LWallace Aviation Inc · Wallace, NEBuilt 1967 · S/N 28-4279 N4915LRoss Robert J · Landisville, PABuilt 1967 · S/N 28-4280 N4916GOngstad Anne Whitman · Robinson, NDBuilt 1979 · S/N 17273463 N4916LMl Monkeybar Inc · Mammoth Lakes, CABuilt 1967 · S/N 28-4281 N4916TArithansa LLC · Big Bear City, CABuilt 1972 · S/N 28-7225281 N4917GCarter Richard W · Bumpass, VABuilt 1979 · S/N 17273464 N4917LBlankenbaker Myron K · Jacksonville Beach, FLBuilt 1967 · S/N 28-4282 N4918FBarnes Charles G · Louisville, KYBuilt 1976 · S/N 28-7715081 N4918LAthene Solutions LLC · Coral Springs, FLBuilt 1967 · S/N 28-4283 N4919FTice Denzil · Farmville, VABuilt 1979 · S/N 17273102 N4919LCroft Jeffrey W · Tennessee Colony, TXBuilt 1967 · S/N 28-4284 N491CMMottinger Casey P · Elizabeth, COBuilt 2012 · S/N 82107 N491DKey City Fliers · Maquoketa, IABuilt 1973 · S/N 28-7325632 N491ETKennebeck Ronald C · Johnston, IABuilt 1968 · S/N 28-24880 N491FLWashington Fliers Inc · Pantego, NCBuilt 1971 · S/N 28-7125304 N491GShelton Christopher O · Aubrey, TXBuilt 1968 · S/N 28-25022 N491JPGuy Jeffrey · Centerburg, OHS/N 491 N491PDAir Ventures Awaits LLC · Middletown, DEBuilt 1974 · S/N M-1574 N4920GEye Candy Aviation LLC · Jacksonville, FLBuilt 1979 · S/N 17273467 N4920LLvc Air LLC · Allen, TXBuilt 1967 · S/N 28-4285 N4921LBarrett Howard L · Austinville, VABuilt 1967 · S/N 28-4286 N4922DD Gordon Aviation Inc · La Jolla, CABuilt 1979 · S/N 17272398 N4922GBishop Air LLC · Elk Grove, CABuilt 1979 · S/N 17273469 N4922LSpanjer William H · Pine Bush, NYBuilt 1967 · S/N 28-4288 N4922VHhd Aviation LLC · Hamilton, OHBuilt 1973 · S/N 172RG0417 N4923DHarrier Aviation LLC · South Saint Paul, MNFirst renewal noticeBuilt 1979 · S/N 17272399 N4923LDevrnja Aero LLC · Louisville, TNBuilt 1967 · S/N 28-4289 N4925FA S Air LLC · Lantana, FLBuilt 1979 · S/N 17273103 N4925GSchwenker David W · Queensbury, NYBuilt 1979 · S/N 17273472 N4926LRedden John V · Mooresville, NCBuilt 1967 · S/N 28-4293 N4927CRegistration Pending · Helena, MTRegistration pending, pending cancellationBuilt 1953 · S/N 18-2116 N4927DGreenville Flight LLC · Greer, SCS/N 17272401 N4927LProfessional Plastic Solutions LLC · Irving, TXBuilt 1967 · S/N 28-4294 N4928EAce Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 17271676 N4928LTwo8lima Llp · Bryan, OHBuilt 1967 · S/N 28-4295 N4929LMaak Air LLC · Wahoo, NEBuilt 1967 · S/N 28-4296 N492ACRobinson Mark A · Carson City, NVS/N 002 N492BNTurner Harvey Jr · Raleigh, NCBuilt 1967 · S/N 28-4167 N492FLMcknight Anna Mae · Vernon, TXBuilt 1971 · S/N 28-7125306 N492LGSunday Punchers LLC · Monrovia, INBuilt 1979 · S/N AA5A0887 N492SFSnohomish Flying Service Inc · Snohomish, WABuilt 1976 · S/N 17268310 N492WAirplane Adventures LLC · Palos Heights, ILBuilt 1956 · S/N 23-611 N492WPAngel Aviation Inc · Peoria, AZBuilt 1979 · S/N 17272684 N492XMcdonald Stuart D · Phoenix, AZS/N REA-001 N4930LG Salisbury & Associates Inc · Prescott, AZBuilt 1967 · S/N 28-4297 N4930UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842241 N4931LThrust Spear Of Tampa LLC · Tampa, FLBuilt 1967 · S/N 28-4299 N49336Krieger Heinz Friedrich · FrenkendorfS/N 1045 N4933LSouthall Charles B · Amelia, OHS/N 28-4301

Back to AD 80-04-03 R2