Skip to content

Registered aircraft · 17,028

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

N973SRRegistration Pending · Kuna, IDRegistration pendingBuilt 1968 · S/N 18258865 N975SRBrown Tyrone · Fontana, CABuilt 1968 · S/N 18258964 N977DDNilsson Winston · Merrill, ORBuilt 1967 · S/N 18257977 N979JFGoodspeed Air Service LLC · Oxford, CTBuilt 1966 · S/N 17254071 N97JBVieira Nunes Da Silva Raphael · Ethel, LABuilt 1966 · S/N 17255305 N9801GTriad Aviation Academy LLC · Greensboro, NCS/N 17259701 N9803CWhite Traci M · Manasquan, NJBuilt 1971 · S/N 17259703 N9803ZBig Horn Aviation Group · Fort Worth, TXBuilt 1982 · S/N U20606668 N9805GSell Edwin D · Woodbury, PABuilt 1971 · S/N 17259705 N9806GDonohue Denis J · Montvale, NJBuilt 1971 · S/N 17259706 N9807GPoshak Jay M · Ely, MNS/N 17259707 N9809GMcclendon Jon L · Kilgore, TXBuilt 1971 · S/N 17259709 N9810GAir America Flight Center LLC · Daytona Beach, FLBuilt 1971 · S/N 17259710 N9811ZBlack Hawk Brothers LLC · Lakeland, FLBuilt 1982 · S/N U20606674 N9815GKenmore Air Harbor LLC · Kenmore, WABuilt 1971 · S/N 17259715 N9816GRicker Harry K · Turner, MEBuilt 1971 · S/N 17259716 N9817GLester Matthew J · Gouldsboro, MEBuilt 1971 · S/N 17259717 N98182Bena Christopher D Trustee · Wasilla, AKBuilt 1967 · S/N 18258531 N98189Kashmere Apartments LLC · Missouri City, TXS/N R172-0244 N9818GGough Gregory · Emmett, IDBuilt 1971 · S/N 17259718 N9821CN5965t LLC · Lehigh Acres, FLFirst renewal noticeBuilt 1969 · S/N 18259988 N9821GGrubelich Mark C · Edgewood, NMBuilt 1971 · S/N 17259721 N9825GKanawha Aviators LLC · Bancroft, WVBuilt 1971 · S/N 17259725 N9827GSpencer Jeffrey · Capistrano Beach, CABuilt 1971 · S/N 17259727 N982SFBauermeister Matthew · Lake Tapps, WABuilt 1970 · S/N P20600644 N9830GGonzalez Nicolas · Naples, FLBuilt 1971 · S/N 17259730 N9834GNielson Douglas W · East Troy, WIBuilt 1971 · S/N 17259734 N9835GPiedmont Flight Inc · Winston Salem, NCBuilt 1971 · S/N 17259735 N9836GSchafhausen Mark G · Spokane, WABuilt 1971 · S/N 17259736 N9838GMcdonald James E · Harleyville, SCS/N 17259738 N983AWGuthrie Robert Paul · Joiner, ARBuilt 1963 · S/N 18254914 N9841GYoxall Jennifer S · Guilford, CTBuilt 1971 · S/N 17259741 N9842ESopko Michael C · Bonita, CABuilt 1975 · S/N 17702328 N9842GNighthawk N8231g LLC · Pompano Beach, FLBuilt 1971 · S/N 17259742 N9843XTidwell Gregery D · Modesto, CAS/N 17255656 N9846GFord Eagles Inc · Plymouth, MIFirst renewal noticeBuilt 1971 · S/N 17259746 N9847GPilot In Command Academy · Miami, FLBuilt 1971 · S/N 17259747 N9848GRicci Mark P · Waterford, MIBuilt 1971 · S/N 17259748 N9849GPray Aviation Inc · Augusta, KSFirst renewal noticeBuilt 1971 · S/N 17259749 N984FAFreedom Aviation Inc · Lynchburg, VABuilt 1971 · S/N 17259928 N9853GParker Steve E · Palmer, AKBuilt 1971 · S/N 17259753 N9855GChoctaw Nation Of Oklahoma · Durant, OKBuilt 1971 · S/N 17259755 N9857GLeaseair LLC · Wilmington, DEBuilt 1971 · S/N 17259757 N9858GRegistration Pending · Dublin, VARegistration pendingBuilt 1971 · S/N 17259758 N9859GLandrum Craig L · Vinita, OKBuilt 1971 · S/N 17259759 N985KARegistered aircraftBuilt 1968 · S/N 17257703 N985KKHutto Azel J III · Lexington, SCBuilt 1968 · S/N 15068908 N9860GCitabria Inc · Auburn, CABuilt 1971 · S/N 17259760 N9861GLaurel Highlands Aeronautical Academy · Latrobe, PAS/N 17259761 N9863GHurricane Airshows Inc · La Porte, TXBuilt 1971 · S/N 17259763

Back to AD 72-03-03 R3