Skip to content

Registered aircraft · 442

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-22-07') 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-22-07') 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-22-07')
    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-22-07')
  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-22-07')
  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-22-07')
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.

N523VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6014 N524UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 3977 N524VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6161 N525VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6332 N526JLJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1546 N526VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 6470 N527JLJetblue Airways Corp · Long Island, NYBuilt 2001 · S/N 1557 N527NKGryphon Trading Company LLC · Fort Lauderdale, FLBuilt 2007 · S/N 2978 N527VLWilmington Trust Na Trustee · Wilmington, DEBuilt 2015 · S/N 6705 N530FLBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1153 N531JLJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1650 N534UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3989 N535UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3993 N536UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4025 N537JTJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1785 N537UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4041 N538UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4050 N539UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4082 N540UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4107 N542UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4134 N543UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4843 N544UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4847 N545UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4850 N546UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4885 N549UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4932 N551UWUmb Bank N A Trustee · Salt Lake City, UTBuilt 2011 · S/N 4940 N552UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4957 N553UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4960 N554UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4966 N556UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5244 N557UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5269 N558UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5282 N559UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5292 N560UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5300 N561UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5317 N562UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5332 N563UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5368 N567UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5728 N568UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5751 N570TABank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 3869 N572UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5899 N573UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5939 N575UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5980 N576UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6027 N578UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6035 N579UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6100 N580UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6133 N581UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6152 N582UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6175 N583UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6181

Back to AD 2000-22-07