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.

N740WJAlm Holding LLC · Winton, CABuilt 1979 · S/N 340A0740 N741FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 611 N741VETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 1404 N742AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6692 N742CKKalitta Air LLC · Ypsilanti, MIS/N 24424 N742FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 613 N743AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6739 N743CKKalitta Air LLC · Ypsilanti, MIBuilt 1993 · S/N 26350 N743FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 630 N744AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22221 N744CKKalitta Air LLC · Ypsilanti, MIBuilt 1993 · S/N 26353 N744FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 664 N745AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6746 N745AXCargo Aircraft Management Inc · Wilmington, OHS/N 22222 N745CKKalitta Air LLC · Ypsilanti, MIBuilt 1998 · S/N 26361 N745FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 668 N746AAMidnight Engineering LLC · Fort Lauderdale, FLS/N 26639 N746FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 688 N746JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3622 N746MNSparta Aviation Group LLC · Loveland, OHBuilt 1990 · S/N 1136 N7470Museum Of Flight Foundation · Seattle, WABuilt 1969 · S/N 20235 N747GFGe Engine Leasing Holdings Inc · Cincinnati, OHBuilt 1994 · S/N 26355 N747HPK & S Aero · Wilmington, DEBuilt 1977 · S/N TC-2034 N747SFAerospace Trust Management LLC Trustee · Wilmington, DES/N 21575 N747VVJk Aero LLC · Altenburg, MOBuilt 1967 · S/N TE-309 N747VWHammer Aviation LLC · Miami, FLBuilt 1967 · S/N LD-360 N747WTHovey Yvonne L · Attica, MIBuilt 1979 · S/N WA19 N748AVNavigator Aviation II Msn 6862 Trust · Wilmington, DEBuilt 2015 · S/N 6862 N748DAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1980 · S/N ME-341 N748FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 633 N7492NTurner Jimmy A · San Antonio, TXBuilt 1968 · S/N TC-1125 N749AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 22226 N749BCAlta 777 LLC · Salt Lake City, UTS/N 33372 N749FDFederal Express Corp · Memphis, TNBuilt 1989 · S/N 536 N74ETThompson Howard Earle Jr · Dadeville, ALS/N TC-619 N74GGDwm Logistics LLC · San Luis Obispo, CABuilt 1998 · S/N 1331 N74HJRegistration Pending · Sheridan, WYRegistration pendingBuilt 1974 · S/N 340-0333 N7501SPressley Aviation LLC · New London, NCBuilt 1963 · S/N TC-413 N7502NBemidji Aviation Services Inc · Bemidji, MNS/N LD-391 N750ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30259 N750AVNavigator Aviation II Msn 7120 Trust · Wilmington, DEBuilt 2016 · S/N 7120 N750AXBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 22227 N750FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 555 N750PCMarilyn Merlot LLC · Kalispell, MTBuilt 1972 · S/N 340-0189 N751ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30798 N751FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 625 N752ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30260 N752AXAeroacq Partners LLC · Laud By Sea, FLS/N 23434 N752CXCargo Aircraft Management Inc · Wilmington, OHS/N 24451 N752DHKalitta Charters II LLC · Ypsilanti, MIBuilt 1981 · S/N 22466

Back to AD 95-26-15 R1