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.
N899ATDelta Air Lines Inc · Atlanta, GAN904CETatonduk Outfitters Limited · Fairbanks, AKN906ATDelta Air Lines Inc · Atlanta, GAN910ATDelta Air Lines Inc · Atlanta, GAN9113DHeikkila Glenn R · Rockland, MAN913DECorsair Two LLC · Hillsboro, ORN915ATDelta Air Lines Inc · Atlanta, GAN918AVBank Of Utah Trustee · Salt Lake City, UTN919ATDelta Air Lines Inc · Atlanta, GAN920ATDelta Air Lines Inc · Atlanta, GAN921ATDelta Air Lines Inc · Atlanta, GAN922ATDelta Air Lines Inc · Atlanta, GAN923ATDelta Air Lines Inc · Atlanta, GAN924ATDelta Air Lines Inc · Atlanta, GAN925ATDelta Air Lines Inc · Atlanta, GAN926ATDelta Air Lines Inc · Atlanta, GAN927ATDelta Air Lines Inc · Atlanta, GAN928ATDelta Air Lines Inc · Atlanta, GAN929ATDelta Air Lines Inc · Atlanta, GAN929DNDelta Air Lines Inc · Atlanta, GAN930ATDelta Air Lines Inc · Atlanta, GAN930CETatonduk Outfitters Ltd · Fairbanks, AKN930DNDelta Air Lines Inc · Atlanta, GAN930TBBoeing Co · Renton, WAN931TBBoeing Company · Renton, WAN932ATDelta Air Lines Inc · Atlanta, GAN932CETatonduk Outfitters Ltd · Fairbanks, AKN933ATDelta Air Lines Inc · Atlanta, GAN934ATDelta Air Lines Inc · Atlanta, GAN934NANational Aeronautics And Space Administration · Houston, TXN935ATDelta Air Lines Inc · Atlanta, GAN935CETatonduk Outfitters Ltd · Fairbanks, AKN936ATDelta Air Lines Inc · Atlanta, GAN937ATDelta Air Lines Inc · Atlanta, GAN938ATDelta Air Lines Inc · Atlanta, GAN939ATDelta Air Lines Inc · Atlanta, GAN9405TFrontera Flight Holdings Inc · Dover, DEN9409FFronteraflight Holdings Inc · Dover, DEN940ATDelta Air Lines Inc · Atlanta, GAN942ATDelta Air Lines Inc · Atlanta, GAN943ATDelta Air Lines Inc · Atlanta, GAN944ATDelta Air Lines Inc · Atlanta, GAN945ATDelta Air Lines Inc · Atlanta, GAN946ATDelta Air Lines Inc · Atlanta, GAN947ATDelta Air Lines Inc · Atlanta, GAN948ATDelta Air Lines Inc · Atlanta, GAN948TWKc Aviation Stem Inc · Kansas City, MON949ATDelta Air Lines Inc · Atlanta, GAN950ATDelta Air Lines Inc · Atlanta, GAN950NSCorsair Two LLC · Hillsboro, OR
Back to AD 2000-15-15