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.
N907SCCrowe Talmadge Layne Jr · Anchorage, AKN907STState Of Alaska Department Of Public Safety · Anchorage, AKN907TTHangar Ak LLC · Sterling, AKN907TWCarpenter Orin C II · Anchorage, AKN907UTClaus Paul E · Chitina, AKN907VCVision Cubs LLC · Deville, LAN907VLBlue Waters Air Charters LLC · San Juan, PRN907WAPea-Wayman Flight LLC · Daytona Beach, FLN907WDWd Aircraft Investments LLC · Anchorage, AKN907WMSpano Darren M · Deville, LAN907XLLunenschloss Michael L · Anchor Point, AKN9080DTrieber Steven M · Eastport, MEN9080LStewarts Aircraft Service Inc · Waynesville, OHN9080NBoeing Co · Renton, WAN9081HRich Lucas Aircraft Sales LLC · Lincoln Park, NJN9081JPerkins Jimmy Keith · Lonoke, ARN9081LReed William B Trustee · San Jose, CAN9081PTriple J Aviation LLC · Turlock, CAN9081VSale Reported · Phoenix, AZSale reportedN9081WStickley John E · Lothian, MDN90829Leading Edge Aviation Consultants LLC · Windsor, CTN9082DLeahy Garry E · Van Wert, IAN9082PAmeneyro David · Walla Walla, WAN90839White Jake W · San Antonio, TXN9083BNorth Coast Flight School Inc · Meadville, PAN9083DSachs Randy S · S Huntington, NYN9083KShuey Robert D III · Albertville, ALN9083LPeavy Michael J · Chico, CAN9083NKnoxville Flyers Inc · Knoxville, TNN9083PRowland Blayne Administrator · Raymondville, TXN9084FIsland Bound LLC · Dunedin, FLN9084PSchafer Timothy M · Ridgefield, CTN9084VLinear Air LLC · Herriman, UTN9085JBligh Michelle C · Oceanside, CAN9085KSale Reported · Grayling, MISale reportedN9085LBlanton Jeffrey D · Valley Center, KSN9085PCross Seth B · Whitewood, SDN9085WColip Lydia · Bowling Green, INN9086DDarrow John K · Soldotna, AKN9086JBrogan William J · Port Matilda, PAN9086KMedia Stew LLC · Carson City, NVN9086PRick Crum Aircraft Sales Inc · Prestonsburg, KYN90874Myers Brian R · South Bend, INN90878Schmoll Steven D · Zimmerman, MNN9087DBolden Family Farms · Little Rock, ARN9087VPyne Jeffery G · Waxhaw, NCN9087WKohlhardt Ronald C Trustee · Cameron Park, CAN9088DMetro Aircraft Co · Bloomington, MNN9088EBrink Kirk H · Greeneville, TNN9088JRiggins Ryan W · Durango, CO
Back to AD 87-10-06 R1