AD 2000-07-27
Registered aircraft · 1,686
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-07-27')
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-07-27')
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-07-27') 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-07-27') 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.
N348NBDelta Air Lines Inc · Atlanta, GAN348NWDelta Air Lines Inc · Atlanta, GAN349NBDelta Air Lines Inc · Atlanta, GAN349NWDelta Air Lines Inc · Atlanta, GAN350NADelta Air Lines Inc · Atlanta, GAN3518JJetran LLC · Horseshoe Bay, TXN351NBDelta Air Lines Inc · Atlanta, GAN351NWDelta Air Lines Inc · Atlanta, GAN35204United Airlines Inc · Chicago, ILN35236United Airlines Inc · Chicago, ILN35260United Airlines Inc · Chicago, ILN35271United Airlines Inc · Chicago, ILN352NBDelta Air Lines Inc · Atlanta, GAN352NWDelta Air Lines Inc · Atlanta, GAN352PSWilmington Trust Co Trustee · Wilmington, DEN353ASAersale Inc · Coral Gables, FLN353NBDelta Air Lines Inc · Atlanta, GAN353NWDelta Air Lines Inc · Atlanta, GAN354NBDelta Air Lines Inc · Atlanta, GAN354NWDelta Air Lines Inc · Atlanta, GAN354PTAmerican Airlines Inc · Fort Worth, TXN355NBDelta Air Lines Inc · Atlanta, GAN355NWDelta Air Lines Inc · Atlanta, GAN355PUAmerican Airlines Inc · Fort Worth, TXN356NWDelta Air Lines Inc · Atlanta, GAN357DCAwas 3896 Trust · Wilmington, DEN357NBDelta Air Lines Inc · Atlanta, GAN357NWDelta Air Lines Inc · Atlanta, GAN357PVWilmington Trust Co Trustee · Wilmington, DEN358NBDelta Air Lines Inc · Atlanta, GAN358NWDelta Air Lines Inc · Atlanta, GAN358PWWilmington Trust Co Trustee · Wilmington, DEN359NBDelta Air Lines Inc · Atlanta, GAN359NWDelta Air Lines Inc · Atlanta, GAN359PXAmerican Airlines Inc · Fort Worth, TXN360NBDelta Air Lines Inc · Atlanta, GAN360NWDelta Air Lines Inc · Atlanta, GAN361NBDelta Air Lines Inc · Atlanta, GAN361NWDelta Air Lines Inc · Atlanta, GAN36207United Airlines Inc · Chicago, ILN36247United Airlines Inc · Chicago, ILN36272United Airlines Inc · Chicago, ILN36280United Airlines Inc · Chicago, ILN362NBDelta Air Lines Inc · Atlanta, GAN362NWDelta Air Lines Inc · Atlanta, GAN363NBDelta Air Lines Inc · Atlanta, GAN363NWDelta Air Lines Inc · Atlanta, GAN364NBDelta Air Lines Inc · Atlanta, GAN364NWDelta Air Lines Inc · Atlanta, GAN365JSAelf Msn 242 LLC · Guaynabo, PR
Back to AD 2000-07-27