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.

N179JMKc Aviation Partners LLC · Wilmington, DES/N 28425 N179UWWilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N 1521 N17BPTeam Yak Attack Inc · Poplar Grove, ILBuilt 1974 · S/N TC-1650 N17KGJamey Johnson Inc · Fisher, LABuilt 1975 · S/N TC-1849 N17KRMerriam Lowell · Chowchilla, CABuilt 1966 · S/N TE-210 N17KWWcs Inc · Troy, ALBuilt 1999 · S/N 1361 N17LCGilpin Kevin E Trustee · Weston, MABuilt 1972 · S/N TC-1474 N17LGGreen & Green Construction Of Grenada Inc · Grenada, MSBuilt 1966 · S/N TE-204 N17MHEcho Aviation LLC · Verona, WIS/N 340A0797 N17WPNorthern Indiana Twin LLC · Valparaiso, INBuilt 1964 · S/N TC-578 N1801LKeenan Brian M · Albuquerque, NMBuilt 1976 · S/N TC-1954 N1804REssex Air LLC · Franklin Lakes, NJBuilt 1981 · S/N WA-269 N1805VMorais Omar · Spring, TXBuilt 1981 · S/N WA-270 N1805WAero Equities LLC · Ventura, CABuilt 1972 · S/N TC-1505 N1806WN1806w LLC · Show Low, AZS/N TC-1506 N18087Small Mountain Flyers LLC · West Monroe, LAS/N ME-415 N180CHPointbank · Pilot Point, TXBuilt 1992 · S/N 1192 N180DNDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 25985 N180FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63111 N180USWilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N 1525 N18112United Airlines Inc · Chicago, ILBuilt 1995 · S/N 27302 N18119United Airlines Inc · Chicago, ILBuilt 1997 · S/N 27561 N1812FLynch Mark R · Forest Lake, MNBuilt 1981 · S/N WA-279 N1812ZHendrickson Todd R · Woodstock, ILBuilt 1981 · S/N WA-280 N1814CSun Desert Enterprises · Spicewood, TXBuilt 1981 · S/N TC-2365 N1814NHenry Mark A · Dickinson, TXBuilt 1981 · S/N WA-282 N1814QWalsh Michael J · Clemmons, NCS/N WA-283 N18151Briggs James E · Nashua, NHBuilt 1981 · S/N WA-285 N18190Miller Chad A · Many, LAS/N TC-2403 N1819RWalsh Michael J · Clemmons, NCBuilt 1981 · S/N WA-296 N181FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63112 N181FLIfl Group Inc · Waterford, MIBuilt 1956 · S/N 387 N181PRCgf 1280 LLC · Wilmington, DES/N 1280 N181US181us LLC · Boca Raton, FLBuilt 1998 · S/N 1181 N181UWAmerican Airlines Inc · Fort Worth, TXS/N 1531 N1820SClark Robert R · Covina, CABuilt 1981 · S/N WA-288 N1820WBoos Lynette J · Providence, RIBuilt 1981 · S/N WA-289 N1821WModern & Classic Aviation LLC · North Royalton, OHBuilt 1973 · S/N TC-1522 N1822SSnider Nancy J · Washington, DCBuilt 1981 · S/N TC-2357 N1823WMuhler Wayne · Brighton, COS/N TC-1509 N1823YSpenner Herbert C · San Jose, CABuilt 1981 · S/N WA-290 N18242Huuki Matt · Atlantic Mine, MIBuilt 1981 · S/N WA-294 N18258Haas Edward L · Conroe, TXBuilt 1982 · S/N WA-299 N1826DDeoiveira Vitor · Shrewsbury, MABuilt 1983 · S/N WA301 N1826WOzark Mountain Airways LLC · Springfield, MOBuilt 1973 · S/N TC-1510 N18273Hussey Mathias C · Frisco, TXBuilt 1977 · S/N TC-2065 N182ANAersale Inc · Coral Gables, FLBuilt 1999 · S/N 29592 N182FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63113 N182UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25279 N182UWWilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N 1536

Back to AD 95-26-15 R1