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.

N672FLD J Aero LLC · Churchville, NYBuilt 1971 · S/N 287125599 N672LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881682 N6730JDietz Craig S · Grants Pass, ORS/N 28-24439 N6730WPrucha Derek L · Hideaway, TXBuilt 1965 · S/N 28-20846 N6731JHensley Douglas S · Newland, NCBuilt 1968 · S/N 28-24826 N6732JSchool Of Missionary Aviation Technology · Ionia, MIS/N 28-24443 N6732WOhlstein Michael R · Glen Head, NYBuilt 1965 · S/N 28-20848 N6733FMarianas Air Transfer Inc · Saipan, MPS/N 28-7725077 N6733JRedman Cory S · Villa Rica, GABuilt 1968 · S/N 28-24444 N6734JApex Airmotive LLC · Frisco, TXBuilt 1966 · S/N 28-20850 N6735WRegistration Pending · Parsons, KSRegistration pendingBuilt 1965 · S/N 28-20854 N6736JJames Roderick V · Boise, IDBuilt 1968 · S/N 28-24447 N6736WVan Der Linden David R · Sweetwater, TNBuilt 1965 · S/N 28-20855 N6737JWalt Richard A · Whittemore, MIBuilt 1968 · S/N 28-24448 N6738WRussell Christopher E · Pontotoc, MSBuilt 1965 · S/N 28-20858 N6739JRafferty Larry M · Mount Vernon, OHBuilt 1968 · S/N 28-24453 N673CTCentral Texas College · Killeen, TXBuilt 2017 · S/N 2844169 N673DTAir Henry LLC · Carthage, MOBuilt 1973 · S/N 28-7410038 N673LHFf22 LLC · Scottsdale, AZS/N 2881683 N673SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881438 N6742JGannone Nanette V · El Prado, NMBuilt 1968 · S/N 28-24827 N6742WMidnight Flight LLC · Wells, TXS/N 28-20863 N6743FHollywood Biplane LLC DBA · Atlanta, GABuilt 1976 · S/N 28-7715176 N6743JStader Noah M · Platteville, WIS/N 28-24459 N6745JHerget Joshua N · Toulon, ILBuilt 1968 · S/N 28-24462 N6746JOn Short Final LLC · Marion, NCBuilt 1968 · S/N 28-24463 N6747WBunn Benjamin D · Winchester, VABuilt 1965 · S/N 28-20871 N6748WCartanian Alfred F · Las Vegas, NVS/N 28-20872 N6749JSebesta Roman T · Brazoria, TXBuilt 1968 · S/N 28-24467 N674APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843775 N674CTCentral Texas College · Killeen, TXBuilt 2017 · S/N 2844170 N674DTMiller Jeffrey Dale · Brookhaven, GABuilt 1969 · S/N 28R-35074 N674FLBackyard Aero LLC · Rockville, INBuilt 1971 · S/N 28-7125602 N674LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881684 N6750JAmin Kirit · Lansdale, PABuilt 1968 · S/N 28-24469 N6750WNelson Laura Leigh · Gastonia, NCBuilt 1965 · S/N 28-20874 N6751JJones James L · White Hall, ARBuilt 1968 · S/N 28-24470 N6752JHutchins James R · Columbia, SCBuilt 1968 · S/N 28-24474 N6753JSpieth John W · Ann Arbor, MIBuilt 1968 · S/N 28-24475 N6755JBon Investment Holdings LLC · Zephyrhills, FLBuilt 1968 · S/N 28-24478 N6755WAeroqualite Maintenance · Cumberland, WIBuilt 1965 · S/N 28-20879 N6756JAmv Aviation LLC · Miami, FLBuilt 1968 · S/N 28-24479 N6756WTrollinger Lari D · Wanette, OKBuilt 1965 · S/N 28-20880 N6758JBroach William S · Forest Hill, MDBuilt 1968 · S/N 28-24828 N6759WMakeev Alexandre · Concord, CABuilt 1965 · S/N 28-20884 N675LBOmalley Kevin S · Cordova, MDBuilt 1977 · S/N 28R-7703389 N675LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881685 N675MPN9sa Corp Trustee · Wilmington, DEBuilt 1972 · S/N 32-7200037 N6760WBitter Loren Mark · Maricopa, AZBuilt 1965 · S/N 28-20885 N6761WGirdley James Kevin · Taylorsville, KYBuilt 1965 · S/N 28-20886

Back to AD 87-08-08 R3