Skip to content

Registered aircraft · 5,440

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:95-26-15-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-15-R1') 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:95-26-15-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-15-R1')
  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:95-26-15-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-15-R1')
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.

N85GC4lions LLC · Chula Vista, CABuilt 1991 · S/N 1161 N85WDAerovision-Logos Aircraft Holdings Vii Corp · Dover, DEBuilt 1987 · S/N 1008 N8605KWadsworth & Wadsworth LLC · Morehead City, NCS/N 340A1241 N860CGLeading Edge Flight Academy LLC · Bend, ORBuilt 1976 · S/N TC-1957 N860DAWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29951 N8625QCorona Robert Jr Dr · Bay Shore, NYFirst renewal noticeS/N TC-779 N862AVAircol 23 · Wilmington, DEBuilt 2011 · S/N 4862 N862DAWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29734 N8630MMerrills Inc · Shreveport, LAS/N TC-497 N8632KEano Air 340 LLC · Highland, UTBuilt 1981 · S/N 340A1243 N8636KM & J General Contractors Inc · Elgin, ILBuilt 1978 · S/N 340A0562 N8637KCommonwealth Capital Corp · Wilmington, DEBuilt 1978 · S/N 340A0604 N8637QLindell Michael S · East Wenatchee, WABuilt 1964 · S/N TC-781 N8638QJeffery Finis B · Washington, DCBuilt 1964 · S/N TC-784 N863DAWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29735 N863TWilliams Roger F · Hayward, CABuilt 1964 · S/N TC-739 N8641MCaldwell Glenn A · Garnett, KSBuilt 1963 · S/N TC-529 N8647KJughead Aircraft LLC · Salina, KSBuilt 1978 · S/N 340A0605 N864BCBoeing Aircraft Holding Co · Seattle, WAS/N 30871 N864CMForss Jamey L · Ferndale, WABuilt 1979 · S/N 340A0683 N864DAWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29736 N864SPiekarski John S · Kuna, IDBuilt 1969 · S/N TC-1208 N8652KDelta Charlie Company LLC · Billings, MTS/N 340A0606 N865BCBoeing Aircraft Holding Co · Renton, WAS/N 30872 N865DAWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29737 N865FSkybus Jet Cargo Inc · Las Vegas, NVBuilt 1969 · S/N 46088 N8669QCopperhead LLC · Murrieta, CABuilt 1964 · S/N TC-802 N866DAWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29738 N8671KFlight Unlimited LLC · Dover, DEBuilt 1978 · S/N 340A0611 N8675KJjjp North LLC · New London, NCBuilt 1978 · S/N 340A0614 N8676Fortmann Christopher S · Okarche, OKBuilt 1966 · S/N TC-964 N867TDecelles Philip P Trustee · Napa, CABuilt 1964 · S/N TC-759 N8683QStar City Flying Carrier LLC · Lincoln, NEBuilt 1964 · S/N TC-810 N8684KWerth Roger · Aberdeen, SDS/N 340A0981 N8689GJm Aircraft Inc · Hickory, NCS/N 340A0323 N868TPatriot Aviation Logistics LLC · Lewes, DEBuilt 1964 · S/N TC-703 N869MDEmo Systems LLC · Wilton Manors, FLBuilt 1999 · S/N 1363 N869SCPerennial Investments Inc · Anaheim, CABuilt 1994 · S/N 1236 N86CBSweeney David P · Gilmer, TXS/N TC-1383 N86MSAb Jet Co II LLC · Metairie, LABuilt 2000 · S/N 1406 N8702KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 340A0623 N8707KDelaware Corp · Topping, VAS/N 340A0982 N870SMarsh Air Corps LLC · North Las Vegas, NVBuilt 1973 · S/N TC-1600 N8711KGraham Thomas R · Bonita Springs, FLS/N 340A0627 N8712KKirkmeyer Thomas · Kimberly, IDBuilt 1978 · S/N 340A0628 N8720KZielinski John P · Queen Creek, AZBuilt 1978 · S/N 340A0631 N8727KFrosty Acres LLC · Hailey, IDS/N 340A0633 N873CAAc Spe 12 LLC · Orlando, FLBuilt 2012 · S/N 1348 N873TBryan John Charles Jr · Mocksville, NCBuilt 1965 · S/N TC-845 N874AAAntares Aviation LLC · Boca Raton, FLBuilt 1978 · S/N 21386

Back to AD 95-26-15 R1