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.

N4461WKimball Douglas S · Bedford, INBuilt 1974 · S/N TC-1677 N4462SMaxxum Financial Group Inc · Destrehan, LABuilt 1975 · S/N TC-1876 N446AVAircol 11 · Wilmington, DEBuilt 2009 · S/N 4046 N446UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 834 N4476WBmg Aviation Leasing LLC · Bloomington, INBuilt 1974 · S/N TC-1809 N447JLKjolsing Jerome M · Camino, CABuilt 1966 · S/N TE-121 N447UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 836 N4481SAc Aviation LLC · Searcy, ARBuilt 1975 · S/N TC-1881 N448SPWilliams Donald B · Sharps Chapel, TNBuilt 1964 · S/N TC-768 N448UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 842 N4490WFrisch Josef C · Belmont, CABuilt 1974 · S/N TC-1683 N449UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 851 N44CEEvergreen Executive Holdings LLC · North Oaks, MNBuilt 1989 · S/N 1125 N44CYMiskell Christopher S · Senoia, GABuilt 1973 · S/N TC-1629 N44GJN44gj LLC · Camden, DEBuilt 2003 · S/N 1508 N44GVN44gv LLC · Pacific Palisades, CABuilt 1997 · S/N 1305 N44MAPacific Mission Aviation · Hagatna, GUS/N LD-412 N44RAJohnson Bruce W · Portland, ORBuilt 1965 · S/N TC-916 N44XFWetzel Jack T · New Port Richey, FLBuilt 1964 · S/N TC-731 N450CFZieger C Philip · Clearwater Beach, FLBuilt 1978 · S/N TC-2128 N450EJPremier Air Charter Inc · Carlsbad, CABuilt 1995 · S/N 1273 N450LHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N TC-2215 N450LRRicotta Lance · Yuma, AZBuilt 1988 · S/N 1013 N450MBAircraft Fidelity Corporation Trustee · Dover, DEBuilt 1996 · S/N 1295 N450NANational Aerotech Aviation Delaware · Wilmington, DES/N U-92 N450PZN800pz LLC · Las Vegas, NVBuilt 1996 · S/N 1299 N4514MSpencer Joseph C · Evans, GABuilt 1978 · S/N TC-2129 N4515QEagle Holding Co LLC · Indianapolis, INS/N 340-0097 N451AVAircol 12 · Wilmington, DEBuilt 2009 · S/N 4051 N451GAStratton Ventures LLC · Wilmington, DEBuilt 1993 · S/N 1221 N451KRAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2001 · S/N 1451 N451PEPa Msn 1451 LLC · Dallas, TXBuilt 2001 · S/N 01451 N451PKMackenzie Matthew S · Sacramento, CAS/N 340-0036 N451UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 865 N4522SSpecialty Surgery Centers Of America Inc · Brentwood, TNBuilt 1975 · S/N TC-1889 N452UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 0955 N4537MBullet Construction LLC · Roswell, NMBuilt 1979 · S/N TC-2234 N453FEFederal Express Corp · Memphis, TNBuilt 1983 · S/N 267 N453LCIron Aviation LLC · Bozeman, MTBuilt 1986 · S/N UB53 N453UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1001 N4540STdc Aviation LLC · Wilmington, DES/N TC-1891 N4546SMid Iowa Equipment · Newton, IABuilt 1975 · S/N TC-1895 N454ATye Eric R · Napa, CABuilt 1963 · S/N TC-533 N454AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5454 N454FEFederal Express Corp · Memphis, TNBuilt 1983 · S/N 278 N454UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1104 N4557NWestra Aviation LLC · Beaver Dam, WIBuilt 1978 · S/N 340A0547 N455BTMarshall Tristen · Spokane Valley, WABuilt 1964 · S/N TC741 N455CMCargo Aircraft Management Inc · Wilmington, OHS/N 26983 N455HCBas Part Sales LLC · Greeley, COS/N TC-586

Back to AD 95-26-15 R1