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.

N554NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26501 N554SDAeroplanes2 LLC · Indianola, IABuilt 1964 · S/N TC-646 N554SLStewart Aviation Services LLC · Birmingham, ALBuilt 1998 · S/N 1343 N554TBOwen Harold E Jr · Collierville, TNBuilt 1976 · S/N TC-1998 N554USHunter Stephen Earle · Anchorage, AKBuilt 1961 · S/N TC-99 N554UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4966 N554WTAerownership North American Services Inc Trustee · Dover, DES/N 28554 N555CPFirebird Air LLC · Fulshear, TXBuilt 1979 · S/N 340A0651 N555ETFlyboys Nevada LLC · Henderson, NVBuilt 1961 · S/N TC-137 N555JECantr Holdings LLC · Fish Creek, WIBuilt 1970 · S/N TC-1329 N555NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 33391 N555PManson Howard William · Pinckney, MIBuilt 1966 · S/N TE-164 N555RDGates Robert H · Santa Barbara, CABuilt 1977 · S/N TC-2025 N555RPGreenwood Auto LLC · Itta Bena, MSS/N TC-2009 N555TMPalm Aerobatic Aircraft LLC · Port Saint Lucie, FLBuilt 1969 · S/N TC-1232 N555TYKiefer Karl F · Spring, TXBuilt 1974 · S/N 340-0515 N556JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1904 N556NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 33392 N556UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5244 N557GGArmo Aviation LLC · Los Angeles, CAS/N 1276 N557NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 33393 N557UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5269 N558CBFrancis Scott P · Montclair, VAS/N TC-1800 N558JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1915 N558UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5282 N559JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 1917 N559LCOlympia Aviation LLC · Detroit, MIBuilt 1995 · S/N 1259 N559MKBadawi Aviation LLC · Orlando, FLBuilt 1979 · S/N ME170 N559TSuperbird Icc LLC · Mitchell, SDBuilt 1961 · S/N TC-108 N559UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5292 N55AEFreer Lawrence C III · Puyallup, WABuilt 1966 · S/N TE-84 N55BNInternational Air Services Inc Trustee · Carson City, NVBuilt 1973 · S/N TC-1572 N55BUBlue Side Up LLC · Oxford, CTBuilt 1978 · S/N TC-2138 N55CNBaron 55cn LLC · Haltom City, TXBuilt 1964 · S/N TC-601 N55CZHall William · Boynton Beach, FLBuilt 1976 · S/N TC-1932 N55FDDieu Est Mon Courage LLC · Fernandina Beach, FLBuilt 1975 · S/N TC-1857 N55HMMoore Brian L · Reno, NVBuilt 1974 · S/N TC-1723 N55MLAlmeida Gabriel · Bellville, TXBuilt 1964 · S/N TC-691 N55RBGots To Go LLC · Wilmington, DEBuilt 1975 · S/N 340A0015 N55RSCrop-Serv Inc · Meade, KSBuilt 1966 · S/N TE-151 N55RVRegistration Pending · Dover, DERegistration pendingBuilt 1975 · S/N TC-1828 N55SABemidji Aviation Services Inc · Bemidji, MNBuilt 1965 · S/N LD-243 N55SEN55se LLC · Frankfort, ILBuilt 1968 · S/N TC-1136 N55SGBas Part Sales LLC · Greeley, COBuilt 1976 · S/N TC-1955 N55SJBk Air LLC · New Brighton, MNBuilt 1982 · S/N TC-2447 N55TDLandlocked Company LLC · Dover, DEBuilt 1990 · S/N 1131 N55TEMaxwell Aviation Inc · Chesterfield, MOFirst renewal noticeBuilt 1975 · S/N TC-1832 N55TSFlying Monkey LLC · Wilmington, DEBuilt 1961 · S/N TC-146 N55VFTjp Aviation Inc · Garrettsville, OHBuilt 1978 · S/N TC-2132 N55VGA And E Aero Ventures LLC · Saline, MIBuilt 1978 · S/N TC-2165

Back to AD 95-26-15 R1