Skip to content

Registered aircraft · 111

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:2004-03-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:2004-03-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:2004-03-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:2004-03-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:2004-03-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:2004-03-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.

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 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 N906ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55087 N910ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55086 N915ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55085 N919ATDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 55084 N920ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55083 N921ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55082 N922ATDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 55050 N923ATDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 55051 N924ATDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 55080

Back to AD 2004-03-21