AD 2002-16-18
Registered aircraft · 1,252
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:2002-16-18')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-16-18')
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:2002-16-18') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-16-18') 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.
N315TSTutor-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, ILN33209United Airlines Inc · Chicago, ILN33262United Airlines Inc · Chicago, ILN33264United Airlines Inc · Chicago, ILN33266United Airlines Inc · Chicago, IL
Back to AD 2002-16-18