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.

N7120PDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-90 N7123NLarson Sven E · Newport Coast, CABuilt 1967 · S/N TC-1046 N7126UDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-93 N7128HDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-94 N712BPPearson Matthew G · Wickenburg, AZBuilt 1973 · S/N TC-1520 N712FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 1758 N712FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7204 N712GLThere And Back LLC · Tulsa, OKBuilt 1975 · S/N 340A0029 N712JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3517 N7130NBlake Charles L · Woodstock, GABuilt 1968 · S/N TC-1059 N7132ZDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-95 N71347Dynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-96 N71351Dynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-97 N7137GDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-99 N7139ZDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-101 N713FEFederal Express Corp · Memphis, TNS/N 1766 N713FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7286 N713JKelly Dent LLC · Wilmington, DEBuilt 1966 · S/N TE-75 N7146XDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-104 N714FEFederal Express Corp · Memphis, TNBuilt 2026 · S/N 1767 N714FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7294 N714UZwicker Brian A · Richmond Hill, GABuilt 1968 · S/N TC-1188 N7151NStroope Rhea H · Campbell, TXBuilt 1968 · S/N TC-1062 N7155PDynamic Avlease Inc · Bridgewater, VABuilt 1968 · S/N LM-107 N7155SDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-112 N7157KDynamic Aviation Group Inc · Bridgewater, VAS/N LM-115 N715FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 7313 N715JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3554 N715JWBlack Forest Applications LLC · Mckinney, TXBuilt 1966 · S/N TE-69 N7169ZDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-123 N716FRWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7524 N716MJAlpine Aviation Inc · Provo, UTBuilt 1992 · S/N UE-16 N7176S403tb LLC · Dover, DEBuilt 1989 · S/N 1119 N71797Dynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-131 N717FDFederal Express Corp · Memphis, TNBuilt 1987 · S/N 361 N717FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7536 N717JCRees Aviation LLC · Rockingham, NCBuilt 2003 · S/N 1513 N717LN717l LLC · Toledo, WABuilt 1973 · S/N TC-1495 N717LCAircraft Capital Partners LLC · Bozeman, MTBuilt 1992 · S/N UE-17 N717TMulti Engine Flight Time LLC · St George, UTBuilt 1962 · S/N TC-321 N717TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 28485 N7181HDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-134 N7181JDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-135 N718AFUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-162 N718FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7575 N718JMPage Field Aviation LLC · Fort Myers, FLBuilt 1979 · S/N TC-2257 N718TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 28486 N7193MDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-139 N7198BDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeS/N LM-141 N7198YDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1972 · S/N LU-02

Back to AD 95-26-15 R1