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.

N9203XPeru Projects Inc · Lincoln, NEBuilt 1962 · S/N 18253603 N92049Put Ronald · Alameda, CABuilt 1969 · S/N 18260019 N92050Tysky Air LLC · Arvada, COBuilt 1969 · S/N 18260020 N92051Yardy Paul J · Caledon OntarioBuilt 1969 · S/N 18260021 N92054Waterheat Inc · Anchorage, AKBuilt 1969 · S/N 18260023 N92059Scott Donald · Bend, ORBuilt 1969 · S/N 18260025 N92061Wright Frederick L · Rosamond, CABuilt 1969 · S/N 18260026 N92065Meyer Ronald W · Carleton, MIBuilt 1969 · S/N 18260030 N92068Lovas Thomas A · Anchorage, AKBuilt 1969 · S/N 18260031 N92069Registration Pending · Redding, CARegistration pendingBuilt 1969 · S/N 18260032 N92074Franz Donald A · Sidney, MTBuilt 1969 · S/N 18260035 N9207GSundin James B · Kahului, HIBuilt 1971 · S/N 18260747 N9207XHegge Darren S · Priest River, IDBuilt 1961 · S/N 18253607 N92089Alves Randy J · Lakeview, ORBuilt 1969 · S/N 18260039 N9208GAdams Shane M · Jonesborough, TNBuilt 1971 · S/N 18260748 N92098Valburg Bill J · Draper, SDBuilt 1969 · S/N 18260042 N92099Jiang Jacky · Riverside, CABuilt 1969 · S/N 18260043 N92106Reese Karl J · Salome, AZBuilt 1969 · S/N 18260047 N92112N92112 LLC · Litchfield Park, AZBuilt 1969 · S/N 18260049 N92114Schwantz Sharee M · Azle, TXBuilt 1969 · S/N 18260050 N92116Dickens Henry V · Morganton, NCS/N 18260051 N92119Albin Robert D · Santa Rosa, CABuilt 1969 · S/N 18260053 N9211XSalter 11x LLC · Duluth, MNS/N 18253611 N92120Westlund Jason Wade · Seattle, WABuilt 1969 · S/N 18260054 N92125Seemann James P · Dade City, FLFirst renewal noticeBuilt 1969 · S/N 18260055 N9212XNs Aviation Inc · Ottumwa, IABuilt 1961 · S/N 18253612 N9213XChung Thomas · Stanwood, WABuilt 1961 · S/N 18253613 N92147Bielstein David P · Plainville, GABuilt 1969 · S/N 18260063 N9214GOwens Joseph F · Tallahassee, FLBuilt 1971 · S/N 18260754 N92150Pessolano Vincent F · Naples, FLBuilt 1969 · S/N 18260064 N92151Adiabatic Adventures LLC · Morrison, COBuilt 1969 · S/N 18260065 N92152Pank Thomas E · Walkersville, MDS/N 18260066 N92158Ackerman Jefferson P · Beaufort, SCBuilt 1969 · S/N 18260068 N9216GComdess Company Inc · Seville, OHBuilt 1971 · S/N 18260756 N92172Fly Like An Eagle LLC · Springfield, MOBuilt 1969 · S/N 18260073 N92175Richards Joseph · Gardiner, NYBuilt 1969 · S/N 18260074 N9217GRegister Otis E · Rolla, MOBuilt 1971 · S/N 18260757 N92180Mahanti Robert L · Flagstaff, AZBuilt 1969 · S/N 18260075 N92183Desselle Trent · New Orleans, LAS/N 18260077 N92184Aviatrix Adventures LLC · Tallahassee, FLBuilt 1969 · S/N 18260078 N92187Med Eagle LLC · Folsom, CABuilt 1969 · S/N 18260079 N9218GTpec LLC · Madison, MSBuilt 1971 · S/N 18260758 N92190Rimkus Fisher · Rio Frio, TXBuilt 1969 · S/N 18260081 N92193Hendricks Alan M · Greenville, TXBuilt 1969 · S/N 18260082 N92198Hanson Steven Dale · Livermore, CABuilt 1969 · S/N 18260084 N921MAMoxie Vincent B · Sarver, PABuilt 1969 · S/N 15071284 N92207Eason William E · Gloucester, MAS/N 18260090 N92208Full Throttle Aviation LLC · Nashville, ARBuilt 1969 · S/N 18260091 N92209Stanton Gregory R Jr · Newport, ORBuilt 1969 · S/N 18260092 N92214Sfh Aviation LLC · Birmingham, MIBuilt 1969 · S/N 18260094

Back to AD 72-03-03 R3