AD 2000-03-51
Registered aircraft · 131
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-03-51')
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-03-51')
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-03-51') 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-03-51') 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.
N906ATDelta Air Lines Inc · Atlanta, GAN910ATDelta Air Lines Inc · Atlanta, GAN913DECorsair Two LLC · Hillsboro, ORN915ATDelta Air Lines Inc · Atlanta, GAN919ATDelta 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, GAN930DNDelta Air Lines Inc · Atlanta, GAN930TBBoeing Co · Renton, WAN931TBBoeing Company · Renton, WAN932ATDelta Air Lines Inc · Atlanta, GAN932NAAstro Zero G One Corp · Dover, DEN933ATDelta Air Lines Inc · Atlanta, GAN934ATDelta Air Lines Inc · Atlanta, GAN935ATDelta Air Lines Inc · Atlanta, GAN936ATDelta Air Lines Inc · Atlanta, GAN937ATDelta Air Lines Inc · Atlanta, GAN938ATDelta Air Lines Inc · Atlanta, GAN939ATDelta Air Lines Inc · Atlanta, GAN940ATDelta 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, GAN949ATDelta Air Lines Inc · Atlanta, GAN950ATDelta Air Lines Inc · Atlanta, GAN951ATDelta 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, GAN961ATDelta Air Lines Inc · Atlanta, GAN963ATDelta Air Lines Inc · Atlanta, GAN963DNBoeing Company · Renton, WA
Back to AD 2000-03-51