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.
N951ATDelta Air Lines Inc · Atlanta, GAN952ATDelta Air Lines Inc · Atlanta, GAN953ATDelta Air Lines Inc · Atlanta, GAN954ATDelta Air Lines Inc · Atlanta, GAN955ATDelta Air Lines Inc · Atlanta, GAN957ATDelta Air Lines Inc · Atlanta, GAN959ATDelta Air Lines Inc · Atlanta, GAN960ATDelta Air Lines Inc · Atlanta, GAN9615WJetran LLC · Horseshoe Bay, TXN9616GJetran LLC · Horseshoe Bay, TXN9617RJetran LLC · Horseshoe Bay, TXN9618AJetran LLC · Horseshoe Bay, TXN9619VJetran LLC · Horseshoe Bay, TXN961ATDelta Air Lines Inc · Atlanta, GAN961CEArctic One LLC · Fairbanks, AKN961TWJetran LLC · Horseshoe Bay, TXN9620DJetran LLC · Horseshoe Bay, TXN9622AJetran LLC · Horseshoe Bay, TXN9624TJetran LLC · Horseshoe Bay, TXN9625WJetran LLC · Horseshoe Bay, TXN9626FJetran LLC · Horseshoe Bay, TXN9628WJetran LLC · Horseshoe Bay, TXN9629HJetran LLC · Horseshoe Bay, TXN962TWJetran LLC · Horseshoe Bay, TXN963ATDelta Air Lines Inc · Atlanta, GAN963CEArctic One LLC · Fairbanks, AKN963DNBoeing Company · Renton, WAN963TWJetran LLC · Horseshoe Bay, TXN964ATDelta Air Lines Inc · Atlanta, GAN964CEArctic One LLC · Fairbanks, AKN964TWJetran LLC · Horseshoe Bay, TXN965ATDelta Air Lines Inc · Atlanta, GAN965CEArctic One LLC · Fairbanks, AKN965TWJetran LLC · Horseshoe Bay, TXN966ATDelta Air Lines Inc · Atlanta, GAN966CEArctic One LLC · Fairbanks, AKN967ATDelta Air Lines Inc · Atlanta, GAN967CEArctic One LLC · Fairbanks, AKN967TWJetran LLC · Horseshoe Bay, TXN968TWJetran LLC · Horseshoe Bay, TXN969TWJetran LLC · Horseshoe Bay, TXN970ATDelta Air Lines Inc · Atlanta, GAN970TWJetran LLC · Horseshoe Bay, TXN971ATDelta Air Lines Inc · Atlanta, GAN972TWJetran LLC · Horseshoe Bay, TXN974ATDelta Air Lines Inc · Atlanta, GAN976TWBank Of Utah Trustee · Salt Lake City, UTN977ATDelta Air Lines Inc · Atlanta, GAN978ATDelta Air Lines Inc · Atlanta, GAN978TWJetran LLC · Horseshoe Bay, TX
Back to AD 2000-15-15