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.
N316NBDelta Air Lines Inc · Atlanta, GAN316NVUmb Bank Na Trustee · Salt Lake City, UTN316PFAmerican Airlines Inc · Fort Worth, TXN317NBDelta Air Lines Inc · Atlanta, GAN317PGAmerican Airlines Inc · Fort Worth, TXN318FLUmb Bank Na Trustee · Salt Lake City, UTN318NBDelta Air Lines Inc · Atlanta, GAN318NVUmb Bank Na Trustee · Salt Lake City, UTN319NBDelta Air Lines Inc · Atlanta, GAN319NVUmb Bank Na Trustee · Salt Lake City, UTN319USDelta Air Lines Inc · Atlanta, GAN320NBDelta Air Lines Inc · Atlanta, GAN320NVSunrise Asset Management LLC · Las Vegas, NVN321NBDelta Air Lines Inc · Atlanta, GAN321NVSunrise Asset Management LLC · Las Vegas, NVN321USDelta Air Lines Inc · Atlanta, GAN322NBDelta 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, NVN325FLUmb Bank Na Trustee · Salt Lake City, UTN325NBDelta Air Lines Inc · Atlanta, GAN325NVSunrise Asset Management LLC · Las Vegas, NVN325USDelta Air Lines Inc · Atlanta, GAN326FLUmb Bank Na Trustee · Salt Lake City, UTN326NBDelta 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, NVN328NWDelta Air Lines Inc · Atlanta, GAN329NBDelta Air Lines Inc · Atlanta, GAN329NVSunrise Asset Management LLC · Las Vegas, NVN329NWDelta Air Lines Inc · Atlanta, GAN3300CCsds Asset Management LLC · Marana, AZN330ADBank Of Utah Trustee · Salt Lake City, UTN330AEBank Of Utah Trustee · Salt Lake City, UTN330NBDelta Air Lines Inc · Atlanta, GAN330NVSunrise Asset Management LLC · Las Vegas, NVN331NBDelta Air Lines Inc · Atlanta, GAN331NVSunrise Asset Management LLC · Las Vegas, NVN33203United Airlines Inc · Chicago, ILN33209United Airlines Inc · Chicago, ILN33262United Airlines Inc · Chicago, ILN33264United Airlines Inc · Chicago, ILN33266United Airlines Inc · Chicago, ILN33284Umb Bank Na Trustee · Salt Lake City, UT
Back to AD 2000-07-27