Skip to content

Registered aircraft · 22,416

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:87-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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.

N8254JParis Air Inc · Vero Beach, FLBuilt 1982 · S/N 28-8216186 N8254NBlum William C · Alma, NEBuilt 1969 · S/N 28-25465 N82554Garnet Aviation LLC · Fort Worth, TXBuilt 1982 · S/N 28-8290160 N82557Zehm Laura L · Monterey, CABuilt 1982 · S/N 28-8290161 N8255JBerkshire Aviation Enterprises LLC · Great Barrington, MAS/N 28-8011140 N8255MPhoenix Wings LLC · Oakland, FLBuilt 1980 · S/N 32R-8013128 N8255WReed Emerson E · Winter Haven, FLBuilt 1965 · S/N 28-2406 N8256EWilliams Evan H · Sebastopol, CABuilt 1980 · S/N 28-8116014 N8256LNordbye Newell H · Eden Prairie, MNBuilt 1982 · S/N 28-8211044 N8256VZ-Tech Research LLC · Greenville, TXBuilt 1980 · S/N 28-8116018 N8256WInland Northwest Flyers LLC · Spokane Vly, WAS/N 28-2407 N8256XSkyriders Inc · Pocatello, IDBuilt 1980 · S/N 28-8190016 N82575Rocky Gary B · Campbell, TXBuilt 1980 · S/N 28-8011141 N8257ETv Air LLC · Raleigh, NCBuilt 1982 · S/N 28-8211045 N8257GDraco Flight School Inc · Chino, CABuilt 1982 · S/N 28-8290162 N8257WHou Barry · San Marino, CABuilt 1965 · S/N 28-2409 N8257YParker William E · Wichita, KSBuilt 1980 · S/N 28R-8031177 N8258LWiesner Loren A Jr · Cameron, WIBuilt 1980 · S/N 28-8116022 N8258NK&G Transit LLC · Fort Mc Coy, FLBuilt 1980 · S/N 28-8116023 N8258WWirkus Branden D · Apo, AEBuilt 1965 · S/N 28-2410 N82593Fisher Chester · Columbia, MDBuilt 1982 · S/N 28R-8231064 N8259BDunn Patrick E · Marthasville, MOBuilt 1980 · S/N 28-8190021 N8259NAughenbaugh Timothy A · Iriquois, SDS/N 28-25471 N8259TNsa Ops LLC · Kahului, HIBuilt 1980 · S/N 28-8190024 N8259WMorrison Daniel S · Hershey, PABuilt 1965 · S/N 28-2411 N825HBGallegos Joel · Yellville, ARBuilt 1967 · S/N 28-10861 N825PBPalm Beach Aircraft Services Inc · Lantana, FLS/N 28-7890442 N825PTIcarus Flyers LLC · Richmond Hill, GABuilt 1973 · S/N 28-7305472 N825RDFrank Richard · West Dundee, ILS/N 32-7640063 N825XSktr Ac LLC · Fallbrook, CABuilt 2006 · S/N 3255043 N8260NSundberg Nicholas William · Stevensville, MTBuilt 1969 · S/N 28-25472 N8260VRed Rifle Aviation LLC · Richmond, TXBuilt 1980 · S/N 28-8116029 N8260YNew Peach Aviation LLC · Brooks, GABuilt 1980 · S/N 28-8116031 N82616Fisher D Bradley · Cleveland, TNBuilt 1980 · S/N 28-8011142 N8261FDaniels Neil Alan · Balaton, MNS/N 28-7790235 N8261HOxford Flying Club Inc · Oxford, CTBuilt 1980 · S/N 28-8190025 N8261SHoffmann David M · Mauston, WIBuilt 1980 · S/N 28-8190027 N8261TDoss Brothers Inc · Lawrenceburg, TNBuilt 1980 · S/N 32-8024043 N82629Dgf & Associates Inc · Irving, TXS/N 28-8216225 N8262ASnider Jay T · Grove City, OHBuilt 1980 · S/N 28-8116033 N8262ESee Robert W · Catawba, NCBuilt 1980 · S/N 28-8190033 N8262HRegistration Pending · Bucyrus, OHRegistration pendingBuilt 1980 · S/N 28-8190034 N8262KHesston College · Hesston, KSBuilt 1982 · S/N 28-8290165 N8262N40 Flight LLC · Fernandina Beach, FLBuilt 1969 · S/N 28-25474 N8262SWisconsin Aviation - Four Lakes Inc · Madison, WIBuilt 1980 · S/N 28-8190035 N8262UHorton Air Ventures LLC · Eustis, FLBuilt 1980 · S/N 28-8190036 N8262WCalhoun Jerry H · Washington, NCBuilt 1965 · S/N 28-2413 N82631Payne Chris · Lafayette, TNBuilt 1980 · S/N 28-8111003 N82632Muskoka Associates Inc · Wilmington, DES/N 28-10859 N82634Aircraft Wings LLC · Gresham, ORBuilt 1980 · S/N 28-8111004

Back to AD 87-08-08 R3