AD 87-20-03 R2
Registered aircraft · 54,015
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:87-20-03-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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.
N92215Indian Lakes Aviation LLC · Cedar Springs, MIN9221CCruson Michelle E · Ontario, ORN9221XBoettger Gordon R · Carson City, NVN9222Erkmann Christopher R Trustee · Chesterfield, MON9222AMccully Kevin W · Payson, AZN9222BGilreath Steven M · Anderson, SCN9222CHall Vincent P · San Diego, CAN9222RWellman A Ryan · San Jose, CAN9222UJdl Services LLC · Centreville, MDN9222XJones Margaret C · San Marcos, TXFirst renewal noticeN9223ABrossard Adam · Olalla, WAN9223GWilson John L · Winchester, KYN9223HHallock Robert C III · Sag Harbor, NYN9224AGauman Dylon M · Wasilla, AKN9224GB9224g LLC · Carthage, NCN92255Kloker Daniel E · Owasso, OKN9225APeterson Scott W · Garfield, KSN9225B25/25 LLC · Pinedale, WYN9225UPrecise Flight LLC · Waukesha, WIN9225XMenix Travis L · Russell Springs, KYN92262William Syme Alexander Howie Trustee · Bozeman, MTN92265Futchagribusiness LLC · Broxton, GAN9226ASchmidt James W · Dousman, WIN9226GLefevre Jonathan W · Haskell, TXN9226HDebt LLC · Yuma, AZN9226UMcnamara Gavin E W · Rancho Cucamonga, CAN9226XJjm3 LLC · Twin Falls, IDN92277Whiskey Bravo Investments LLC · Bulverde, TXN92280Look To The Sky LLC · Middletown, DEN92281Jera Aviation LLC · Brooksville, FLN92282Registered aircraftN92286Wpr Group LLC · Clinton, MSN9228GDouthitt Kevin S · Long Bch Twp, NJN92291Media Stew LLC · Carson City, NVN92298Ponderosa Aviation LLC · Safford, AZN92299Barxbar Aviation LLC · Mesa, AZN9229APotter Gary W · Abilene, TXN9229GKhademi Amin · Chino Hills, CAN9229TLorenzen Kraig E · Pagosa Springs, CON922AKSanderson David C · Fort Davis, TXN922DUp Jump Enterprises LLC · Morristown, TNN922DBWaldron Stephen W · Murfreesboro, TNN922EAButler Ronald A · Cumming, GAN922MAirline Maintenance Service Inc · Nashville, TNN922MATeton Leasing LLC · Pocatello, IDN922RASchubert Brothers Aviation Inc · Canandaigua, NYN922SWGhulam A Jafferi · South Miami, FLN922VBPilotwire LLC · Argyle, TXFirst renewal noticeN92306High Wingers Inc · Racine, WIN92307Lowcountry Flight LLC · Johns Island, SC
Back to AD 87-20-03 R2