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.

N290CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2010 · S/N 40564 N290FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63135 N290NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2191 N290PMPlanemasters Ltd · West Chicago, ILBuilt 1987 · S/N UB71 N290PSNappyboy Skyhaus LLC · Roswell, GABuilt 1999 · S/N 1376 N290SWBerry Aviation Inc · San Marcos, TXBuilt 1996 · S/N 120317 N290XCMojave Jet LLC · Wilmington, DES/N 290 N29124United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27565 N29129United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28969 N291BPJackson Jeffrey L · Manchester, TNBuilt 1966 · S/N TC-979 N291FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63134 N291GXGlobal Crossing Airlines Inc · Miami, FLBuilt 2007 · S/N 3349 N291NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2206 N291SWFreight Runners Express Inc · Milwaukee, WIBuilt 1996 · S/N 120.318 N291VKV-Jet Aircraft Holding Co Trustee · Dover, DES/N 1466 N2920GStevenson Taylor A · Dallas, TXBuilt 1980 · S/N 340A0115 N292APlacebo Air LLC · Ridgecrest, CABuilt 1966 · S/N LJ-99 N292FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63133 N292NVBank Of Utah Trustee · Salt Lake City, UTS/N 4891 N293FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63132 N293NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4913 N293UXAmeriflight LLC · Dallas, TXBuilt 1994 · S/N 120.293 N29401Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 29401 N294ARJet Midwest Inc · Kansas City, MOS/N 29404 N294FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63131 N294NVBank Of Utah Trustee · Salt Lake City, UTS/N 4941 N294TLAviation Inventory Resources Inc · Alvarado, TXBuilt 1997 · S/N 340B-294 N295FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63130 N295NVBank Of Utah Trustee · Salt Lake City, UTS/N 4942 N296BJc Aircraft Leasing LLC · Wasilla, AKBuilt 1964 · S/N TC-600 N296FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64056 N296NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2674 N297DMFocht Ronald D · Fort Myers, FLBuilt 1980 · S/N TC-2351 N297NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2778 N297SWBerry Aviation Inc · San Marcos, TXBuilt 1996 · S/N 120.327 N298AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-298 N298BCFlight School Of Gwinnett · Lawrenceville, GABuilt 1978 · S/N ME-59 N298CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2010 · S/N 40565 N298NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2800 N298RBSmb G-IV IV LLC · Longwood, FLBuilt 1998 · S/N 1341 N29950Nichols William K · Bainbridge, GABuilt 1974 · S/N TC-1760 N299CZN299cz LLC · Milwaukee, WIBuilt 1969 · S/N U74 N299FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 64059 N299MBOne World Aviation 299 LLC · Atlanta, GAS/N 1231 N299NVAllegiant Air LLC · Las Vegas, NVBuilt 2011 · S/N 4870 N29BEAltaii Ali · Gibraltar, MIBuilt 1971 · S/N 340-0005 N29RBAdvantage Aviation Services LLC · South Saint Paul, MNS/N TD-174 N29RKRhk Of Kansas Inc · Jefferson City, MOBuilt 1982 · S/N TC-2451 N2BBLowry Air LLC · Tahlequah, OKBuilt 1972 · S/N TC-1447 N2CFKentucky Aviation Solutions LLC · Frankfort, KYS/N 340A0319

Back to AD 95-26-15 R1