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.
N9294BHall Justin E · York, NEN9294NCmhw LLC · Memphis, TNN9294PJensen Thomas · Durango, CON9294QPlane Training LLC · Rapid City, SDN9294VMulligan Sean S · Kitty Hawk, NCN9294WBorkowski Brian L · Irwin, IAN9295DStanford Jay H · Anchorage, AKN9295GMcavian LLC · Westworth Village, TXN9295HMiami Seaplane Tours Inc · Miami, FLN9295SSteadman John Harold · Santa Clarita, CAN9295VSt Denis Robert G · Lake City, FLN9295WH&H Aircraft LLC · Scottsbluff, NEN9296HSmith Richard A · Burnsville, MNN9296JAlpha Kilo Aviation LLC · Wasilla, AKN9296NSunrider Aviation Inc · Irvine, CAN9296PStevens John W · Westlake Village, CAN9296SShindel Mark · Los Gatos, CAN9296VOswald Paul C · Shohola, PAN9297C831 Aviation LLC · Salinas, CAN9297EGod'S Country Aviation LLC · Trapper Creek, AKN9297MBowers Matthew Monroe · Dayton, NVN9297P9797p LLC · San Angelo, TXN9297WTorrey Robert E · Pleasant Hill, CAN9297YHart Linda B · San Antonio, TXN9298DAims Air LLC · Kingsport, TNN9298JSt Pete Aviation Services LLC · Saint Petersburg, FLN9298LLangenberg Stewart M · Santa Barbara, CAN9298PBlackhawk Airventures LLC · Wilmington, DEN9298SQuality Aviation Inc · Atlanta, GAN9298VJones Eric S · Tucson, AZN9298WUniversal Avn Inc · La Cygne, KSN9298ZFrederick Ag LLC · Humboldt, KSN9299BBird Acquisition LLC · Phoenix, AZN9299JLucas Steven R · Canton, OHN9299PFusion Flight Management LLC · Lake Havasu City, AZN9299SSky King Flying Club Inc · Jackson, OHN9299XSchoepel Alexandra E Trustee · Templeton, CAN929AArcher Aero LLC · Wilmington, DEN929BMSuntops Aircraft Holding LLC · Lakeland, FLN929BYPorter Ronald A · Waco, TXN929CEMeyer Jonathan · Douglas, WYN929CMCanyon West LLC · Amarillo, TXN929DFFanning Dale E · Chesapeake, VAN929DJA And S Flying Services Inc · Bristol, VAN929DWGreen Bryan D · Brenham, TXN929ELPatterson Bryan J · Brooks, GAN929GSRegistered aircraftN929JARegistered aircraftN929JCBurris Wesley Jay II · Richmond, TXN929KKDavies Lincoln J · Oostburg, WI
Back to AD 87-10-06 R1