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.
N9859WBerry Meredith W III · Covington, LAN985ACRainey Aerial Ag Service Inc · Obion, TNN985BDLesmeister Dean · Kindred, NDN985CGCole Gregory E · Mechanicsville, MDN985CPCivil Air Patrol Inc · Maxwell Afb, ALN985DMSanve Karl · Elk City, OKN985EAStich David · Casper, WYN985FAFreedom Aviation Inc · Lynchburg, VAN985KARegistered aircraftN985MSSteele William G · Warrenton, VAN985NDUnd Aerospace Foundation · Grand Forks, NDN985RBCutrer Raymond R · Kentwood, LAN985RHHarris Robert · Franklinton, LAN985RVGoodrich Matthew · Apple Valley, CAN985TGGregorski Thomas E · Kenly, NCN985WWuya Charlene F · Bethel, AKN986Waterman David K · Temple City, CAN9860GCitabria Inc · Auburn, CAN9860QKennedy Roxanne L · Half Moon Bay, CAFirst renewal noticeN9860WCalkins Ray · Socorro, NMN9861CBell Richard H · Blairsville, GAN9861GLaurel Highlands Aeronautical Academy · Latrobe, PAN9861QFallon Muni Flyers LLC · Fallon, NVN9861UWalther Joseph A · Aledo, TXN9862AAstrup Lloyd H · Mesa, AZN9862HTaf Aerial Services LLC · Beeville, TXN9862JNew River Flying Club Inc · Beaver, WVN9862WWagler Randal Clarence · Bradenton, FLN98637United States Air Force Owner · Elmendorf Afb, AKN9863GHurricane Airshows Inc · La Porte, TXN9863LAspire Aviation LLC · Farmingdale, NYN9863UHedin John A · Charlotte, NCN9863WRohde Bruce G · Fife, WAN98646Seitz David · Gordonville, TXN9864CAerowest LLC · Wilmington, DEN9864GHoppers James W Jr · Milan, TNN9864LCivil Air Patrol Inc · Maxwell Afb, ALN9864QWayman Keith · Longmont, CON9864USiegrist Dean P · Tarpon Springs, FLN9864WDuell David J · Sparks, NVN98651Milton Aviation Inc · Mohegan Lake, NYN98652Bartron J Stark III · Tunkhannock, PAN9865GWheeler John W · River Ranch, FLN9865VPierce Aero LLC · Moore, SCN9865YCloose Brian D · Carlton, MNN9866G198 Main Street Aviation LLC · Sullivan, WIN9866JKembel Robert D · Saint Ignatius, MTN9866LNo Limits Aviation · Hayden, IDN9866YMummey Gary E · Stockport, OHN9867DStewart Jacob A · Turner, MT
Back to AD 87-10-06 R1