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.

N70292Dynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-18 N702CAAc Spe 5 LLC · Orlando, FLBuilt 1994 · S/N 27217 N702DLBohlke LLC · Kingshill, VIBuilt 1966 · S/N TE-136 N702FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 1681 N702FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6825 N702GHSej Air LLC · Beverly Hills, CABuilt 2002 · S/N 1497 N702JFJ F Air LLC · Beverly Hills, CABuilt 2004 · S/N 1528 N702LTKruse Capital Partners LLC · Huntsville, ALBuilt 2004 · S/N 1527 N7034ERange View Investments LLC · Austin, TXBuilt 1962 · S/N LF-49 N70356Dynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-25 N7036LDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-26 N7038YDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-28 N7039TDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-30 N703CKKalitta Air LLC · Ypsilanti, MIBuilt 1990 · S/N 24226 N703FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 1686 N703JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3381 N703KWEastern Airlines LLC · Kansas City, MOBuilt 1991 · S/N 24343 N703RSS3b Leasing LLC · Alexandria, VAFirst renewal noticeS/N 340B252 N7043NDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-38 N7047DDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-41 N704CCMorris Kevin J · Ross, CABuilt 1964 · S/N TC-678 N704FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6845 N704SGJones Aviations LLC · Lexington, MABuilt 2003 · S/N 1504 N704YBMelon Eric H · Chalfont, PABuilt 1968 · S/N TC-1156 N7052XDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-45 N7052YDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-47 N7057KAmazon.Com Services LLC · Seattle, WAS/N 1546 N705DNJetran LLC · Horseshoe Bay, TXBuilt 2009 · S/N 29742 N705FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 1736 N705FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6891 N705GGUnited States Government · Fort Belvoir, VABuilt 1981 · S/N 48 N705JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3416 N705KBRegistered aircraftBuilt 2000 · S/N 1429 N705KWEastern Airlines LLC · Kansas City, MOBuilt 1992 · S/N 24342 N705SVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 1038 N705TWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28479 N7062WDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-49 N7063DDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-50 N70648Dynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-53 N7064QDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-52 N7066XDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-54 N7067SDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-55 N7069FDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-56 N706FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 1739 N706FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6926 N706JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3451 N706KWEastern Airlines LLC · Kansas City, MOBuilt 1990 · S/N 24339 N7078JLiberty University School Of Aeronautics · Lynchburg, VAS/N LM-67 N7078LDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-69 N7079SDynamic Avlease Inc · Bridgewater, VAS/N LM-70

Back to AD 95-26-15 R1