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.
N9680QAircraft Guaranty Corp Trustee · Oklahoma City, OKN96810Gordin Michael E · Lakeland, TNN96814Airplane Leasing LLC · Jupiter, FLFirst renewal noticeN9681HDavis Lester Jr · George West, TXN9681VCooperative Cross Roads Flying Club · Albuquerque, NMN9681XCentral Aviation LLC · White City, ORN96821Tdm Aviators LLC · Madison, ALN9682HCloutblazer LLC · Sacramento, CAN9682VBanks Michael R · Macon, MSN96836Visalia Flyers LLC · Visalia, CAN96839Eastern Shore Aviation · Onancock, VAN9683BTita Enterprises LLC · Apex, NCN9683HCook Samuel Jordon · Thibodaux, LAN9683QBering Capital LLC · Anchorage, AKN9683TFroes Carlos D · Avondale, AZFirst renewal noticeN9683XBates Roger · Palm Beach Gardens, FLN96840Brad Force One LLC · Terre Haute, INN96843Southside Air LLC · Bakersfield, CAN96844Flying Truckster LLC · Denver, CON9684QOgden Laurence B · Weaverville, NCN9684TKobe Thomas J · Lake Placid, FLN96852Inland Northwest Flyers LLC · Spokane Valley, WAN9685BJones Jason B · Anchorage, AKN9685GAltitude Asset Management LLC · Waukesha, WIN9685HBoys Will Fly LLC · Mapleton, UTN9685TBas Part Sales LLC · Greeley, CON9685VBlue Skies Aviation Of Wisconsin Inc · Pulaski, WIN96867Skywarrior Flight Training Inc · Pensacola, FLN9686HHope Lapsley G · Blountville, TNN9686QPetter John W · Wallis, TXN9686XMclenaghan Alvin N · Phoenix, AZN96879Gc Aviation Services-1 LLC · Miamisburg, OHN9687EFrohbieter Jack A · Newtown, PAN9687HBell Gary E · Bend, ORN9687QBron Chris R · Springfield, ILN9687TPractical Software Solutions Inc · Windsor, CON9687VCothron Walter A · Angleton, TXN96883Knash Partners Nwa LLC · Summers, ARN96885Chord Line LLC · East Hampton, NYN9688QF And W Flyers Inc · Newman, ILN9688XDrm Aviation LLC · Glencoe, ALN96890Llewellyn James R · Bainbridge Island, WAN96893Neu Rick L · Kingwood, TXN9689BCoffin Robert H · Wasilla, AKN9689QOptic Air LLC · Sioux Center, IAN9689TSutphen Clinton M · Saint Hedwig, TXN968AAWings Over Texas Holdings LLC · Denton, TXN968HCMarsh Flying Services LLC · El Dorado, KSN968KOpheim Kurt · Minnetrisia, MNN968MSMount San Antonio College Associated · Walnut, CA
Back to AD 87-20-03 R2