AD 2000-12-01
Registered aircraft · 1,270
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-12-01')
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-12-01')
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-12-01') 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-12-01') 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.
N314NBDelta Air Lines Inc · Atlanta, GAN3159GUmb Bank Na Trustee · Salt Lake City, UTN315DNBank Of Utah Trustee · Salt Lake City, UTN315NBDelta Air Lines Inc · Atlanta, GAN315TSTutor-Saliba Corp · Sylmar, CAN3160GUmb Bank Na Trustee · Salt Lake City, UTN316NBDelta Air Lines Inc · Atlanta, GAN316NVUmb Bank Na Trustee · Salt Lake City, UTN317DNUmb Bank Na Trustee · Salt Lake City, UTN317NBDelta Air Lines Inc · Atlanta, GAN318DXDelta Air Lines Inc · Atlanta, GAN318FLUmb Bank Na Trustee · Salt Lake City, UTN318NBDelta Air Lines Inc · Atlanta, GAN318NVUmb Bank Na Trustee · Salt Lake City, UTN319BDDepartment Of The Air Force · Hill Afb, UTN319DNDelta Air Lines Inc · Atlanta, GAFirst renewal noticeN319NBDelta Air Lines Inc · Atlanta, GAN319NVUmb Bank Na Trustee · Salt Lake City, UTN319USDelta Air Lines Inc · Atlanta, GAN320NBDelta Air Lines Inc · Atlanta, GAN321NBDelta Air Lines Inc · Atlanta, GAN321USDelta Air Lines Inc · Atlanta, GAN322NBDelta Air Lines Inc · Atlanta, GAN323DNBank Of Utah Trustee · Salt Lake City, UTN323NBDelta Air Lines Inc · Atlanta, GAN32404United Airlines Inc · Chicago, ILN324CHN324ch LLC · Miami, FLN324NBDelta 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, NVN327JTRegistered aircraftN327NBDelta 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, GAN329NWDelta Air Lines Inc · Atlanta, GAN330DXBank Of Utah Trustee · Salt Lake City, UTN330FLBank Of Utah Owner Trustee · Salt Lake City, UTN330NBDelta Air Lines Inc · Atlanta, GAN330NVSunrise Asset Management LLC · Las Vegas, NVN331DNBank Of Utah Trustee · Salt Lake City, UTN33203United Airlines Inc · Chicago, IL
Back to AD 2000-12-01