Registered aircraft · 40,472

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.

N2727YFreedom Aviation LLC · Dover, DEBuilt 1958 · S/N TD-79 N2728PBrown James A · Fairbanks, AKBuilt 1955 · S/N 22-3034 N2728QDanmick Holdings LLC · Dickson, TNFirst renewal noticeBuilt 1977 · S/N 28-7790416 N2728WNash Richard D · Edgewood, WABuilt 1966 · S/N 3339 N2729XMoeplanes Co · Boynton Beach, FLBuilt 1970 · S/N AA1-0320 N272ACFlying Radish LLC · Vineyard Haven, MABuilt 1998 · S/N 1253-98 N272BDDanby James D · High Rolls, NMBuilt 2001 · S/N 001 N272CCFarkas Jordan C · Anchorage, AKBuilt 2001 · S/N 9925CC N272CPPetracca Carmine O D · Lewiston, IDBuilt 1983 · S/N 272 N272DBBrock Dean R · Hawthorne, FLBuilt 1973 · S/N 17261821 N272DKKroutil David W · Hilmar, CABuilt 1978 · S/N 17271857 N272DRMiller Seth A · Sahuarita, AZBuilt 1985 · S/N 272DR N272FDFly Dynasty Corp · Ocala, FLBuilt 1968 · S/N 28-24693 N272GTNfh Aviation LLC · Pikeville, KYS/N 44-7995054 N272JAGold Coast Aviation LLC · Oxnard, CABuilt 1976 · S/N 17267439 N272KMHickman Michael G · Longmont, COBuilt 1997 · S/N 5003 N272KSOlson Richard · Eau Claire, WIBuilt 1967 · S/N 28-23936 N272RARomeo Alpha Flyers Inc · Nashville, TNBuilt 1974 · S/N 17263700 N272RRGray Kerry · Monterey, CABuilt 1973 · S/N 17261914 N272TLSanders Flight Training Center · Jasper, ALS/N 17270719 N272TNReed Perry L · Mooresville, NCBuilt 1977 · S/N 17268803 N272WCCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272677 N272ZMarson Richard W · Eagle River, AKBuilt 1998 · S/N 1050 N2730EOew Aviation LLC · Sumter, SCBuilt 1978 · S/N 17271309 N2730WKegg Larry R · Chesapeake, VABuilt 1966 · S/N 3429 N2731MBosn Richard O · Scottsbluff, NEBuilt 1977 · S/N 28-7890265 N2733WMclenaghan Alvin N · Phoenix, AZBuilt 1966 · S/N 3341 N27347Cochran Douglas C · Saranac Lake, NYBuilt 1954 · S/N 18-4032 N2735PTaylor William W Jr · Hudson Oaks, TXBuilt 1955 · S/N 22-3042 N2736PBeard Jared · Fallon, NVBuilt 1955 · S/N 22-3043 N2737JClair Brent · Loraine, ILBuilt 1979 · S/N 17273643 N2738WMead James R · Jonesboro, ARFirst renewal noticeBuilt 1966 · S/N 260 N2739WKessler Henry L · San Gabriel, CABuilt 1966 · S/N 3344 N2739YEnnis Michael J · Eminence, MOBuilt 1958 · S/N TD-92 N273AAHammerschlag Richard S · Kamiah, IDBuilt 1959 · S/N TD-321 N273BGates Hiram P · Faribault, MNBuilt 1959 · S/N 131 N273CCRegenald Michaud Aviation LLC · Willows, CABuilt 2001 · S/N 9920CC N273EBNorth Country Aircraft Holdings LLC · Watertown, NYBuilt 1978 · S/N 17271018 N273JFParrish Aviation Flight Academy LLC · Southlake, TXS/N 17261732 N273NDPurdue Aviation LLC · West Lafayette, INBuilt 2000 · S/N 28-42073 N2741YCoelum LLC · Lake Mary, FLBuilt 1958 · S/N TD-94 N2742DLloyd Land Plane III LLC · Brighton, COBuilt 1952 · S/N 25284 N27446Evans William Henry Jr · Gardendale, TXBuilt 1939 · S/N 2088 N2744JOvation Cwa LLC · Prairie Du Sac, WIBuilt 1979 · S/N 17273644 N2744VHerrenkohl Robert D · Bay Point, CAS/N 3346 N2745ZKlabunde Andrew G · Menasha, WIBuilt 1978 · S/N 357-78 N2746PParish Brandon · Mendon, UTBuilt 1955 · S/N 22-3053 N2746YDavenport Jimmy J · Hayesville, NCBuilt 1958 · S/N TD-104 N2747GVogt Mark Allen · San Diego, CABuilt 1967 · S/N 143 N2747PSvendsen Jon A · Wasilla, AKBuilt 1955 · S/N 22-3054

Back to AD 80-04-03 R2