AD 2000-15-15
Registered aircraft · 229
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
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-15-15')
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-15-15')
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-15-15') 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-15-15') 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.
N586AAAerothrust Holdings Leasing LLC · Miami, FLN590AAFrontera Flight Holdings Inc · Dover, DEN595AAPac Blue Aerospace · Fairbanks, AKN603ATDelta Air Lines Inc · Atlanta, GAN607ATDelta Air Lines Inc · Atlanta, GAN608ATDelta Air Lines Inc · Atlanta, GAN637SHPacific Aircorp 49741 Inc · San Francisco, CAFirst renewal noticeN697BJTexas Air And Space Museum Inc · Amarillo, TXN717JLDelta Air Lines Inc · Atlanta, GAN721MNBd Md-87 LLC · Longwood, FLN730BCDelta Air Lines Inc · Atlanta, GAN734BCDelta Air Lines Inc · Atlanta, GAN7520AAerothrust Holdings Leasing LLC · Miami, FLN7541AFrontera Flight Holdings Inc · Dover, DEN7548AFrontera Flight Holdings Inc · Dover, DEN7550Frontera Flight Holdings Inc · Dover, DEN763BCDelta Air Lines Inc · Atlanta, GAN782TWSierra American Corp · Wilmington, DEFirst renewal noticeN783TWSierra American Corp · Wilmington, DEN784TWSierra American Corp · Wilmington, DEN798BCDelta Air Lines Inc · Atlanta, GAN799BCDelta Air Lines Inc · Atlanta, GAN801WACaribbean Sun Airlines Inc DBA · Miami, FLN805MLSmb Md-87 II LLC · Longwood, FLN806WA53251 LLC · Miami Springs, FLN807WAFederal Dynamics Corp · Henderson, NVN808WACaribbean Sun Airlines Inc · Miami, FLN813TLGeoairgroup LLC · Wilmington, DEN817BCDelta Air Lines Inc · Atlanta, GAN820BCDelta Air Lines Inc · Atlanta, GAN826BCHawaiian Airlines Inc · Honolulu, HIN832USUSA Jet Airlines Inc · Belleville, MIN833USUSA Jet Airlines Inc · Belleville, MIN834USUSA Jet Airlines Inc · Belleville, MIN835USUSA Jet Airlines Inc · Belleville, MIN836USUSA Jet Airlines Inc · Belleville, MIN837USUSA Jet Airlines Inc · Belleville, MIN842USUSA Jet Airlines Inc · Belleville, MIN861GAWorld Atlantic Leasing LLC · Miami Springs, FLN883BCHawaiian Airlines Inc · Honolulu, HIN883GAFalcon Commercial Aviation LLC · Miami, FLN886BCDelta Air Lines Inc · Atlanta, GAN887GARising Sun Aviation LLC · Irving, TXN891ATDelta Air Lines Inc · Atlanta, GAN892ATDelta Air Lines Inc · Atlanta, GAN892BCDelta Air Lines Inc · Atlanta, GAN893ATDelta Air Lines Inc · Atlanta, GAN894ATDelta Air Lines Inc · Atlanta, GAN895ATDelta Air Lines Inc · Atlanta, GAN896ATDelta Air Lines Inc · Atlanta, GA
Back to AD 2000-15-15