Skip to content

Registered aircraft · 131

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-03-51') 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-03-51') 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-03-51')
    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-03-51')
  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-03-51')
  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-03-51')
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.

N158JPAerotrust Services Corp Trustee · Wilmington, DES/N 53195 N218JPAerotrust Services Corp Trustee · Wilmington, DES/N 53305 N475HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55121 N476HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55118 N477HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55122 N478HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55123 N479HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55124 N480HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55125 N483HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55128 N484HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55129 N485HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55130 N486HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55131 N487HAHawaiian Airlines Inc · Honolulu, HIBuilt 2001 · S/N 55132 N488HAHawaiian Airlines Inc · Honolulu, HIBuilt 1998 · S/N 55001 N489HAHawaiian Airlines Inc · Honolulu, HIBuilt 1998 · S/N 55002 N490HAHawaiian Airlines Inc · Honolulu, HIBuilt 2000 · S/N 55151 N491HAHawaiian Airlines Inc · Honolulu, HIBuilt 2003 · S/N 55175 N492HAHawaiian Airlines Inc · Honolulu, HIBuilt 2004 · S/N 55181 N493HAHawaiian Airlines Inc · Honolulu, HIBuilt 2005 · S/N 55184 N494HAHawaiian Airlines Inc · Honolulu, HIBuilt 2004 · S/N 55182 N495HAHawaiian Airlines Inc · Honolulu, HIBuilt 2004 · S/N 55185 N603ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55127 N607ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55074 N608ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55081 N717JLDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 55042 N730BCDelta Air Lines Inc · Atlanta, GAS/N 55176 N734BCDelta Air Lines Inc · Atlanta, GAS/N 55177 N763BCDelta Air Lines Inc · Atlanta, GAS/N 55167 N798BCDelta Air Lines Inc · Atlanta, GAS/N 55169 N799BCDelta Air Lines Inc · Atlanta, GAS/N 55170 N817BCDelta Air Lines Inc · Atlanta, GAS/N 55171 N820BCDelta Air Lines Inc · Atlanta, GAS/N 55173 N826BCHawaiian Airlines Inc · Honolulu, HIS/N 55183 N832USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53259 N833USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53215 N834USUSA Jet Airlines Inc · Belleville, MIBuilt 1990 · S/N 53115 N835USUSA Jet Airlines Inc · Belleville, MIBuilt 1990 · S/N 53172 N836USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53214 N837USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53257 N842USUSA Jet Airlines Inc · Belleville, MIBuilt 1992 · S/N 53380 N883BCHawaiian Airlines Inc · Honolulu, HIS/N 55190 N886BCDelta Air Lines Inc · Atlanta, GAS/N 55191 N891ATDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 55043 N892ATDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 55044 N892BCDelta Air Lines Inc · Atlanta, GAS/N 55192 N893ATDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 55045 N894ATDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 55046 N895ATDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 55047 N896ATDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 55048 N899ATDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 55049

Back to AD 2000-03-51