AD 87-10-06 R1
Registered aircraft · 72,010
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-10-06-R1')
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-10-06-R1')
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-10-06-R1') 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-10-06-R1') 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.
N9750JBaltz Aviation Services LLC · Mercer, WIN9750LLouisiana Department Of Public Safety · Baton Rouge, LAN9750QPurdy Adrian · Missouri City, TXN9751JR&A Aviation LLC · Flower Mound, TXN9751MSchott Milbert F · Richland Center, WIN9751UCox Glenn E · Denton, NEN97528Sky Warrior Flight Training Inc · Pensacola, FLN9752BUniversity Of Alaska Anchorage · Anchorage, AKN9752CAero-Sphere Inc · Longmont, CON9752LHickox Richard E · Las Cruces, NMN9752NDearman Larry · Stonyford, CAN9752QStrojny Andrew P Jr · Strongsville, OHN9752UBg Aero Ltd Co · Coyle, OKN9753UJ&M Aviation LLC · Atkinson, NEN9753WSeppala Matthew T · Hortonville, WIN9754DLaney Charles A · Maiden, NCN9754MZiaja Rebecca · Virginia Beach, VAN9755DSkyline Solutions Inc · Deland, FLN9755JDesroches John · Scottsdale, AZN9755LClendenen William M · Spencer, TNN9755WAncheta Kai A · Anchorage, AKN9756JJackson Robert L · Leesburg, VAN9757JCarbiener Diane M · Kewanee, ILN9757LGasper Joseph · New Port Richey, FLN9757UFairchild James C · Pinson, TNN9757WTld And Company LLC · Trenton, FLN9758BSherwood Aviation LLC · Lewes, DEN9758DEvans Michael K · Nome, AKN9758JKiarsis Stephen G · West Wareham, MAN9759HHavelka Glen C · Boerne, TXN9759JLazy H LLC · Carleton, NEN975AAEmez Holdings LLC · Boca Raton, FLN975ACNaples Air Center Inc · Naples, FLN975BESaucerman & Company LLC · Hampstead, NCN975BSSaurdiff Benjerman D · Two Rivers, AKN975BWWeidendorf Investments LLC · Hinckley, MNN975DGPhillips Duke · Hyattville, WYN975DSJpm Aviation LLC · Irvine, CAN975GPSalah Danny · Moraga, CAN975LEBlue Borracho LLC · Manitou Springs, CON975LLWoodhouse William H · Power, MTN975PKMaisel Chad · Plano, TXN975RVArvai Joseph · Elkridge, MDN975SGage Christopher R · Truckee, CAN975VTDodd Park A · Richmond, VAN976Green Alexander · Germantown, TNN9760CStreet Steven J · Rochester, MIN9760DDavis Michael P · Midway, UTN9760JHanks Cathy J · Danville, KYN9760MNeal Alan B · Cherry Valley, CA
Back to AD 87-10-06 R1