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.

N1511AAtlas Air Inc · Purchase, NYBuilt 1989 · S/N 24318 N151ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6840 N151FClark Robert G · Healdsburg, CABuilt 1964 · S/N TC-613 N151FEFederal Express Corp · Memphis, TNBuilt 2017 · S/N 43630 N151FLIfl Group Inc · Waterford, MIBuilt 1953 · S/N 51 N151SDAviation Company Inc · Cheyenne, WYBuilt 1994 · S/N 1249 N151UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 834 N151UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5513 N1523Msn 1523 LLC · San Diego, CABuilt 2001 · S/N 1523 N1524ZColumbus Baron Partners Llp · Columbus, GABuilt 1961 · S/N TC-218 N1529SRich Aviation Services LLC · Fort Worth, TXBuilt 1963 · S/N TC-528 N152AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6887 N152BGBlossman Gas Of North Carolina Inc · Swannanoa, NCBuilt 1976 · S/N TC-2015 N152FEFederal Express Corp · Memphis, TNBuilt 2017 · S/N 43552 N152UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 835 N152UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5588 N1531ZShenandoah Whalen · Amelia, OHBuilt 1961 · S/N TC-205 N153ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6908 N153FEFederal Express Corp · Memphis, TNBuilt 2017 · S/N 63095 N153GAAlpine Aviation Inc · Provo, UTBuilt 1985 · S/N UB-34 N153GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-153 N153UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 0839 N153UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5594 N1545ZMcpherson Russell H · Forest Lake, MNS/N TC-213 N154AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6928 N154CRed River Aircraft Leasing LLC · Anchorage, AKBuilt 2002 · S/N 1493 N154FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 42730 N154GGlf4 1044 LLC · Fort Lauderdale, FLBuilt 1987 · S/N 1044 N154GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-25 N154GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-154 N154QBrandon Sidney Jordan III · Dundas, VABuilt 1964 · S/N TC-798 N154UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0840 N154UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5644 N1552WT3 Aerosports LLC · Vian, OKBuilt 1972 · S/N TC-1444 N155AGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N TC2311 N155CJUe-55 LLC · Helena, MTS/N UE-55 N155DMHarden Aviation LLC · Washington, PABuilt 1978 · S/N 340A0511 N155FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 43631 N155JAStavrides Paul · Hartsville, PABuilt 1976 · S/N TC-1993 N155JB2mec Holdings LLC · Kalispell, MTBuilt 1966 · S/N TC-1025 N155NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6940 N155STAzimi Shahram · Hayward, CABuilt 1964 · S/N TC-651 N155UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5659 N1561WEmpresas Marex Inc · Mayaguez, PRS/N TC-1445 N1564SRegistered aircraftBuilt 1962 · S/N TC-313 N1567AKarsten Steven R · San Juan Capo, CABuilt 1969 · S/N TC-1270 N1568GUas Transervices Inc · Boca Raton, FLS/N UC-58 N1569LRegistered aircraftBuilt 1976 · S/N TC-1945 N156AMMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1996 · S/N 1296 N156ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6983

Back to AD 95-26-15 R1