AD 2020-03-21
Registered aircraft · 523
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:2020-03-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2020-03-21')
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:2020-03-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2020-03-21') 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.
N69JPPaul Air LLC · San Juan, PRN6FEFederal Express Leasing Corp · Memphis, TNN700HMHarbert Global Aviation LLC · Birmingham, ALN700YBYb Global LLC · Mequon, WIN702ERRegistered aircraftN702LKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN704MFMc Group · Santa Monica, CAN708TTWilmington Trust Co Trustee · Wilmington, DEN70MJTornante Co LLC · Beverly Hills, CAN70PSRi Mercury LLC · Beverly, MAN711MCN&Md Investment Corp · Missoula, MTFirst renewal noticeN711WKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN711WMGaughan Flying LLC · Las Vegas, NVN715TSTvpx Trust Co LLC · North Salt Lake, UTN716TVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN717DXDsg Finance LLC · Coraopolis, PAN717KDSky Range Aviation LLC · Sioux Falls, SDN717NTMarila Leasing LLC · Chamblee, GAN718DDFlt 2 LLC · Dallas, TXN718DTTse Leasing LLC · Short Hills, NJN720WLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN721MSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN723HAHagan Properties Inc · Louisville, KYN723HHAircraft Trust & Financing Corp Trustee · Wilmington, DEN724JJKoga Air LLC · San Luis Obispo, CAN724MFMbf Leasing Of Florida LLC · Coral Gables, FLN724MTGtbk LLC · Buffalo, NYN725CSC&S Wholesale Grocers Inc · Keene, NHN726AFBank Of Utah Trustee · Salt Lake City, UTN726BFWilmington Trust Co Trustee · Wilmington, DEN730DDDpm Aviation LLC · Dover, DEN731SR83/80 LLC · New York, NYN7413BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN74DHHalbert & Associates LLC · Irving, TXN75JJJtjd Aviation LLC · Belleair, FLN75VBParamount Pictures Corp · Van Nuys, CAN770AGUnited States Air Force · Hanscom Afb, MAN770KFKw770 LLC · Bozeman, MTN771BKKaiser Aviation LLC · Waterford, MIN7777UTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN778CHCsc Delaware Trust Co Trustee · Wilmington, DEN77NZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN77SCBls Phenom LLC · Lawrenceville, GAN787KJTvpx Trust Co LLC Trustee · North Salt Lake, UTN787NBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN788MMBank Of Utah Trustee · Salt Lake City, UTN78SDLiquid Aviation Inc · Del Mar, CAN793APCsc Delaware Trust Co Trustee · Wilmington, DEN793XInvolo LLC · New York, NYN797CTCaterpillar Inc · Fort Worth, TX
Back to AD 2020-03-21