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.
N96809Folsom Realty Group Inc · Greenville, MEN9680CGregorski Thomas E · Kenly, NCN9680DGoundry George D · Sammamish, WAN9680JAltizer Joseph F · West Logan, WVN9680PB407 LLC · Seattle, WAN9680QAircraft Guaranty Corp Trustee · Oklahoma City, OKN9680TK And K Recycling Inc · Fairbanks, AKN9680WConrady Colt · Laguna Niguel, CAN9681DLynch Sean L · Brighton, ILN9681FSplashdown Aviation LLC · Dunedin, FLN9681HDavis Lester Jr · George West, TXN9681PHibbert Kim O · Anchorage, AKN9682HCloutblazer LLC · Sacramento, CAN9682JLenz Frank M · Boca Raton, FLN9682MMccormick Borrero Ramon A · Ponce, PRN9682NOhman Chris M · Tulsa, OKN9682PHutchison Don D · Wounded Knee, SDN9682VBanks Michael R · Macon, MSN9682WCullen Clay T · Danbury, CTN96836Visalia Flyers LLC · Visalia, CAN96839Eastern Shore Aviation · Onancock, VAN9683BTita Enterprises LLC · Apex, NCN9683DSmith James A · Lyle, WAN9683HCook Samuel Jordon · Thibodaux, LAN9683JDale Allyson K I · Clarkston, MIN9683MPourteau Patrick Steven · West Columbia, TXN9683PWarthog Flying Service Inc · Stuttgart, ARN9683QBering Capital LLC · Anchorage, AKN9683UNorris Tracy N · Channelview, TXN9683WHincy William P · Palmdale, CAN9684JBlackstone Aircraft LLC · Hartselle, ALN9684MMayes John · Carson City, NVN9684PNotti Jae A · Otter, MTN9684QOgden Laurence B · Weaverville, NCN9684SGt Aviation LLC · Kalispell, MTN9684WGousios Eleni E · Rocklin, CAN9685CCendejas Agustin · Chino, CAN9685DPadgett Matthew K · Star City, ARN9685ESwanson Michael J · Wayzata, MNN9685GAltitude Asset Management LLC · Waukesha, WIN9685HBoys Will Fly LLC · Mapleton, UTN9685PJones Victor E · Cordova, AKN9685UCochran Brad · Humboldt, TNN9685VBlue Skies Aviation Of Wisconsin Inc · Pulaski, WIN96867Skywarrior Flight Training Inc · Pensacola, FLN9686HHope Lapsley G · Blountville, TNN9686JPohl Andrew L · Zephyrhills, FLN9686KGaasedelen Trading Co · Edina, MNN9686MMccarty Joseph P · Atlanta, GAN9686PT-6 Warbird LLC · Tulsa, OKFirst renewal notice
Back to AD 87-10-06 R1