AD 2000-05-08
Registered aircraft · 695
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-05-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:2000-05-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:2000-05-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:2000-05-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.
N302NVSunrise Asset Management LLC · Las Vegas, NVN305NVSunrise Asset Management LLC · Las Vegas, NVN306NVSunrise Asset Management LLC · Las Vegas, NVN307NVSunrise Asset Management LLC · Las Vegas, NVN308NVSunrise Asset Management LLC · Las Vegas, NVN309NVSunrise Asset Management LLC · Las Vegas, NVN311NVSunrise Asset Management LLC · Las Vegas, NVN312NVSunrise Asset Management LLC · Las Vegas, NVN313NVSunrise Asset Management LLC · Las Vegas, NVN314NBDelta Air Lines Inc · Atlanta, GAN315NBDelta Air Lines Inc · Atlanta, GAN315NVSunrise Asset Management LLC · Las Vegas, NVN316NBDelta Air Lines Inc · Atlanta, GAN316NVUmb Bank Na Trustee · Salt Lake City, UTN317NBDelta Air Lines Inc · Atlanta, GAN318NBDelta Air Lines Inc · Atlanta, GAN318NVUmb Bank Na Trustee · Salt Lake City, UTN319NBDelta Air Lines Inc · Atlanta, GAN319NVUmb Bank Na Trustee · Salt Lake City, UTN320NBDelta Air Lines Inc · Atlanta, GAN320NVSunrise Asset Management LLC · Las Vegas, NVN321AVCsds Asset Management LLC · Marana, AZN321NBDelta Air Lines Inc · Atlanta, GAN321NVSunrise Asset Management LLC · Las Vegas, NVN3221CBank Of Utah Trustee · Salt Lake City, UTN322NBDelta Air Lines Inc · Atlanta, GAN322NVSunrise Asset Management LLC · Las Vegas, NVN323NBDelta Air Lines Inc · Atlanta, GAN323NVSunrise Asset Management LLC · Las Vegas, NVN324NBDelta Air Lines Inc · Atlanta, GAN324NVSunrise Asset Management LLC · Las Vegas, NVN325NBDelta Air Lines Inc · Atlanta, GAN325NVSunrise Asset Management LLC · Las Vegas, NVN326NBDelta Air Lines Inc · Atlanta, GAN326NVSunrise Asset Management LLC · Las Vegas, NVN327NBDelta Air Lines Inc · Atlanta, GAN327NVSunrise Asset Management LLC · Las Vegas, NVN328NBDelta Air Lines Inc · Atlanta, GAN328NVSunrise Asset Management LLC · Las Vegas, NVN329NBDelta Air Lines Inc · Atlanta, GAN329NVSunrise Asset Management LLC · Las Vegas, NVN330NBDelta Air Lines Inc · Atlanta, GAN330NVSunrise Asset Management LLC · Las Vegas, NVN331NBDelta Air Lines Inc · Atlanta, GAN331NVSunrise Asset Management LLC · Las Vegas, NVN332NBDelta Air Lines Inc · Atlanta, GAN332NVSunrise Asset Management LLC · Las Vegas, NVN333NBDelta Air Lines Inc · Atlanta, GAN334NBDelta Air Lines Inc · Atlanta, GAN334NVSunrise Asset Management LLC · Las Vegas, NV
Back to AD 2000-05-08