Skip to content

Registered aircraft · 81,720

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N15484Thompson Mark L · Kirksville, MOBuilt 1972 · S/N 28-7325076 N15489Black Knights Transportation Services LLC · Garden Grove, CABuilt 1972 · S/N 28-7325079 N1548HShrader Brian K · Marion, INBuilt 1975 · S/N 177RG0722 N1548PUS Aviation Training Solutions · Titusville, FLBuilt 2005 · S/N 0199 N1548RJohnson Jimmy G A III · Edmond, OKBuilt 1975 · S/N AA5B-0048 N15493Midwest Flying Service Inc · Elgin, NEBuilt 1972 · S/N 28-7310050 N15499Lankford Toby C · Canadian, TXBuilt 1972 · S/N 28-7325080 N1549ADirk Chantz M · Rapid City, SDS/N 20-752 N154ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010049 N154AVDaviation Inc · Willoughby, OHBuilt 1985 · S/N 28-8616018 N154CPCivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283319 N154DMMason David W · Reklaw, TXBuilt 1963 · S/N DM-001 N154DSIn Flight Aircraft LLC · Howell, MIBuilt 2004 · S/N 40.461 N154ERN154er LLC · Kissimmee, FLBuilt 1989 · S/N 2841182 N154FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2006 · S/N 18281785 N154FTMiloud Chadd K · Fort Worth, TXS/N 28-8216194 N154GRRussell Gregory · Stevensville, MDBuilt 1976 · S/N AA5A-0213 N154JBLevingston Brendan W · Denali Park, AKBuilt 1979 · S/N 15282685 N154MASportsman Airpark Inc · Newberg, ORBuilt 2001 · S/N 260008 N154MDSwenson John E · Belgrade, MTS/N 154MD N154PAParagon Airplane Leasing Co · Fort Myers, FLBuilt 2020 · S/N 28020012 N154PKPerry Patrick J · Dallas, PABuilt 2001 · S/N 154 N154RAFulwiler Air LLC · Green Bay, WIBuilt 2005 · S/N 1391-2005 N154RVLavalley Thomas L · Colorado Springs, COBuilt 2015 · S/N 004 N154SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4151 N154SKReign Aviation LLC · Fresno, CABuilt 1978 · S/N 15282110 N154TKornchuk Kurt C · Wasilla, AKS/N 18-2268 N154WKObx Airplanes LLC · Manteo, NCBuilt 1974 · S/N 451-74 N154ZJAttitude Aerobatics LLC · Wilmington, DEBuilt 2018 · S/N 3312 N154ZPAirsign Airships America LLC · Williston, FLBuilt 1999 · S/N 104 N15504N15504 LLC · Eatontown, NJBuilt 1972 · S/N 28-7325082 N1550EWilts George W · Streator, ILBuilt 1978 · S/N 17271043 N1550VJar Investments LLC · Kalispell, MTBuilt 1974 · S/N 17263655 N1550XVictors Vectors LLC · Valparaiso, INS/N 28R-7535323 N15510Lok Kevin K · Upper Sandusky, OHBuilt 1972 · S/N 28-7305084 N15517Little Ralph D · Rockwall, TXBuilt 1972 · S/N 28-7325085 N15518Registration Pending · Concord, CARegistration pendingBuilt 1972 · S/N 28-7325086 N1551PPhillips Kris D · Cordova, AKBuilt 1954 · S/N 18-3704 N1551RRegistration Pending · Plumas Lake, CARegistration pendingBuilt 1976 · S/N AA1B-0601 N1551SVoelker Craig C · Mount Pleasant, IABuilt 1972 · S/N 28-7305085 N1551VBumpe Logistics LLC · South Jordan, UTBuilt 1974 · S/N 17263656 N1552Scholz Francis M · Atchison, KSBuilt 1971 · S/N DVI-001 N15523Derryberry Clay · Lewisburg, TNBuilt 1972 · S/N 28R-7335065 N15524Brown Gerald · Apple Valley, MNBuilt 1972 · S/N 28R-7335066 N15526Reynolds David K · Bastrop, LABuilt 1972 · S/N 28-7310052 N15529Pattie Donald D · Zephyrhills, FLBuilt 1972 · S/N 34-7350072 N1552HLewis Daniel Bryce · Waller, TXBuilt 1975 · S/N 177RG0726 N1552JBoles Brian D · Watkinsville, GABuilt 1967 · S/N 28-23956 N1552PErickson James M · Wasilla, AKS/N 18-3705 N15533Standard Day Aviation LLC · Garland, TXBuilt 1972 · S/N 28-7325091

Back to AD 81-18-04 R2