Skip to content

Registered aircraft · 1,354

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:2000-05-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-05-21') 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:2000-05-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-05-21')
  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:2000-05-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-05-21')
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.

N805NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0552 N805UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0783 N806AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1056 N806JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5302 N806NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0578 N806UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0788 N807AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1064 N807JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5312 N807NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0588 N807UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0798 N808AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1088 N808NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0591 N808UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0804 N809AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1111 N809JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5349 N809NWDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 0663 N809UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0825 N810AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1116 N810NWDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 0674 N810UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0843 N811NWDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 0690 N811UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0847 N812AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1178 N812NWDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 0784 N812UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0850 N813AWWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 1223 N813NWDelta Air Lines Inc · Atlanta, GAS/N 0799 N813UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0858 N814AWWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 1281 N814NWDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 0806 N814UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0862 N815AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1323 N815NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0817 N815UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0867 N816AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1350 N816NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0827 N816UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0871 N817AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1373 N817CMCargo Aircraft Management Inc · Wilmington, OHS/N 1269 N817NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0843 N817UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0873 N818AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1375 N818NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0857 N818UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0882 N819AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1395 N819NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0858 N819UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0893 N820AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1397 N820NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0859 N820UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0898

Back to AD 2000-05-21