Skip to content

Registered aircraft · 40,471

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.

N9942WMccafferty R Joseph · Winfield, MOBuilt 1967 · S/N 28-23486 N9942YHardy John R · Wasilla, AKBuilt 1962 · S/N 150 N9943ELerud Peder E · Stockton, CABuilt 1979 · S/N 17272294 N9943QGrove Todd M · Lake Stevens, WABuilt 1976 · S/N 17265887 N9943URandall Steve · Oakland, CABuilt 1977 · S/N AA5A0343 N9943YDehlin James M · Roscommon, MIBuilt 1962 · S/N 143 N9944CLarsen John E · Adrian, MIS/N S-48 N9944DRed Baron LLC · Dickinson, NDS/N 18-7013 N9944QSkywarrior Flight Training Inc · Pensacola, FLBuilt 1975 · S/N 17265888 N9945EWilcox John C · Aurora, NEBuilt 1979 · S/N 17272295 N9945PBonner Richard A · Garrettsville, OHBuilt 1976 · S/N 18-7709011 N9945QClassic Air Aviation LLC · Mesa, AZBuilt 1975 · S/N 17265889 N99467Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276451 N9946QHorizon Aviation LLC · Sinclair, MEBuilt 1975 · S/N 17265890 N9946WHangar 0205 Inc · Calhoun, GABuilt 1967 · S/N 28-23491 N9947WDwinal Gary Lee · Lisbon, MEBuilt 1967 · S/N 28-23492 N9948QPemberton Addison J · Spokane, WABuilt 1954 · S/N 18-3557 N9948UDully David F W · Fernandina Beach, FLBuilt 1977 · S/N AA5A0348 N9949RJeca Flight LLC · Liberal, KSBuilt 1960 · S/N TD-388 N994CS994 Charlie Sierra Inc · Jacksonville, FLBuilt 1978 · S/N 28-7990089 N994KSEegt Inc · Helena, MTBuilt 2001 · S/N 90058 N994MBAquila Air Charter LLC · Wilmington, DEBuilt 1985 · S/N 28-8590037 N99507Alyeska Helicopters LLC · Girdwood, AKBuilt 2002 · S/N 3386 N99508Lee Randall Ross · Houston, TXBuilt 1985 · S/N 17276456 N9950DSierra Charlie Aviation LLC · Sandpoint, IDS/N 22-6738 N9950QTymitz Peter A · Eagle River, AKBuilt 1955 · S/N 18-3563 N9950WPlane Jane Aviation LLC · Lincoln, NEBuilt 1967 · S/N 28-23495 N9950YAnders Rod D · Wasta, SDS/N 7GCB-156 N99517Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276459 N9951DDicenzo Eugene N · Cumberland, RIBuilt 1959 · S/N 22-6739 N9951V9951v Aircraft Leasing LLC · Spanish Fork, UTS/N 17264569 N99527Delta State University · Cleveland, MSBuilt 1985 · S/N 17276460 N9952DLynch John E · Bourbonnais, ILBuilt 1959 · S/N 22-6740 N99532Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276462 N9953DNiner Niner Five Three Delta LLC · Marshall, WIS/N 22-6742 N9953YBlock Larry F · Palmer, AKS/N 7GCB-157 N9954DJoy Derek T · Bad Axe, MIBuilt 1959 · S/N 22-6743 N99553Jka LLC · Notasulga, ALBuilt 1985 · S/N 17276465 N99554Briner Micah · Martinsville, INBuilt 1977 · S/N C-1 N9955QWerba Travis J · Anchorage, AKBuilt 1955 · S/N 18-3918 N9955RWhitefish Mountain Acft Rentals & Flt School LLC · Whitefish, MTS/N TD-426 N9955UMatteson Gary E · Monmouth, ORBuilt 1977 · S/N AA5A0355 N9956RMiga Holdings LLC · Flower Mound, TXBuilt 1960 · S/N TD-394 N9957DLinett Michael J · Elsmere, DEBuilt 1959 · S/N 22-6746 N9957EReisman Richard H · Montrose, COBuilt 1979 · S/N 17272298 N9957QHarmon Michael D · Mansfield, SDBuilt 1954 · S/N 54-2535 N9957UTurner Steven R · Westfield, INBuilt 1977 · S/N AA5A0357 N99583Motz Gary A · Bemidji, MNBuilt 1985 · S/N 17276471 N99589Kingsky Flight Academy LLC · Lakeland, FLBuilt 1985 · S/N 17276472 N9958DMoore William H · Johnstown, COBuilt 1959 · S/N 22-6748

Back to AD 80-04-03 R2