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.
N9485FGonzales David M · Corvallis, ORN9485JBlakely Jerry II · Coeur D Alene, IDN9485PMiddlebrook Eric · Anchorage, AKN9485VBrown Douglas B · Petaluma, CAN9486BMccoy Robert P · Fairbanks, AKN9486CRhodes Ryan · Dallas, TXN9486JJames Andy K · Shallowater, TXN9486KAerial Avionics Inc · Modesto, CAN9486NRahimi Navid B · Silver Spring, MDN9487JElmenhurst Daniel D · Walla Walla, WAN9487KInverted Air LLC · Mesa, AZN9487RBoyer Air Lc · West Des Moines, IAN9487WPikes Peak Fliers LLC · Colorado Springs, CON9488DClear Prop Aviation LLC · Sioux City, IAN9488GTap Solutions Inc · San Diego, CAN9488JSneed Associates LLC · Fort Morgan, CON9488PAntes James H · Northfield, MAN9488VMarlow Michael L · Bandera, TXN9489FHensley Richard · Bertram, TXN9489JIndiana County Flying Club Inc · Blairsville, PAN9489VReeder John Galen · Cedar Falls, IAN948DBBoard David N · Moundsville, WVN948JTThompson James L · Thousand Oaks, CAN948RVGeer Roy R · Fort Worth, TXN948SAPavlatos Plato Nicholas · Springfield, OHN948SMScenic Concepts LLC · La Crosse, WIN948TPray Aviation Inc · Augusta, KSFirst renewal noticeN948WDAndrews Aviation Two LLC · Temple, TXN9490HNovak Rickson J · Pine City, MNN9490PSurti Freddy Rusi · Des Moines, WAN9491JRoy Thomas M Jr · Carbondale, ILN9491NWalker Mark L · Turlock, CAN9491PClearprop Consulting LLC · Boynton Beach, FLN9492FDeer Creek Helicopters LLC · Chico, CAN9492HSchodack Aviation Association · Ghent, NYN9492NKnaust Kurt · Baldwinsville, NYN9492VRivera Jaime · San Antonio, TXN9492WHixson Robert S · Los Alamos, NMN9493DJack Browns Seaplane Base Inc · Winter Haven, FLN9493JHayes Enterprises · Glendale, AZN9493NHigh Prairie Aviation LLC · Washington, IAN9493PNeidert Melvin E · Ulysses, KSN9494CChristensen Robert R · Mattawa, WAN9494DReder Monte D · Miles City, MTN9494JRuiz Serge · Montgomery, TXN9494RBig Squirrelly LLC · Kalispell, MTN9494WDavisson Michael A · Edgewood, NMN9495DEichholz Kenneth D · Cordova, TNN9495HNelson Flying Service LLC · Lansford, NDN9495NNagel Richard A · Mequon, WI
Back to AD 87-10-06 R1