AD 2002-03-08
Registered aircraft · 143
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:2002-03-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-03-08')
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:2002-03-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-03-08') 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.
N718BABoeing Aircraft Holding Co · Renton, WAN719FDFederal Express Corp · Memphis, TNN722FDFederal Express Corp · Memphis, TNN723FDFederal Express Corp · Memphis, TNN724FDFederal Express Corp · Memphis, TNN726FDFederal Express Corp · Memphis, TNN727FDFederal Express Corp · Memphis, TNN728FDFederal Express Corporation · Memphis, TNN729CAAc Spe 6 LLC · Orlando, FLN729FDFederal Express Corp · Memphis, TNN730FDFederal Express Corp · Memphis, TNN740FDFederal Express Corp · Memphis, TNN741FDFederal Express Corp · Memphis, TNN742FDFederal Express Corp · Memphis, TNN743FDFederal Express Corp · Memphis, TNN744FDFederal Express Corp · Memphis, TNN745FDFederal Express Corp · Memphis, TNN746FDFederal Express Corp · Memphis, TNN747BCBoeing Aircraft Holding Co · Seattle, WAN748FDFederal Express Corp · Memphis, TNN749FDFederal Express Corp · Memphis, TNN750FDFederal Express Corp · Memphis, TNN751FDFederal Express Corp · Memphis, TNN756CAAc Spe 4 LLC · Orlando, FLN772ETAlta 777 LLC · Salt Lake City, UTN780BABoeing Aircraft Holding Co · Renton, WAN785CKKalitta Air LLC · Ypsilanti, MIN786CKKalitta Air LLC · Ypsilanti, MIN794UAUnited Airlines Inc · Chicago, ILN812NWDelta Air Lines Inc · Atlanta, GAN814NWDelta Air Lines Inc · Atlanta, GAN815NWDelta Air Lines Inc · Atlanta, GAN816NWDelta Air Lines Inc · Atlanta, GAN817NWDelta Air Lines Inc · Atlanta, GAN818NWDelta Air Lines Inc · Atlanta, GAN819NWDelta Air Lines Inc · Atlanta, GAN820NWDelta Air Lines Inc · Atlanta, GAN821NWDelta Air Lines Inc · Atlanta, GAN842BABoeing Co · Renton, WAN859NWDelta Air Lines Inc · Atlanta, GAN860NWDelta Air Lines Inc · Atlanta, GAN861NWDelta Air Lines Inc · Atlanta, GAN884BABoeing Co · Renton, WA
Back to AD 2002-03-08