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.
N8971DThomas James W · Jay, FLN8971JSwearingen Louis S · Summerfield, FLN8971PDerrel Luce Pc · Waco, TXN8971VGibson Aviation Services LLC · Hudson, WIN8971YLaubscher John E · Cazenovia, NYN89721Propability One LLC · Daytona Beach, FLN8972CBosn Richard O · Scottsbluff, NEN8972DClarke Timothy B · Howard, SDN8972JPascua Jonathan J · Coventry, RIN8972PHardy Douglas · Lakewood, CAN8972VPearce Michael J · Phoenix, AZN8972WIma Pilot LLC · Sauk Rapids, MNN8973DSnider Scott E DBA · Turner, MTN8973FAvelan Enterprises Inc · Elm Grove, LAN8973JMuleshoe Flight Club LLC · Muleshoe, TXN8973PBrockwell Derrell Randel · Oakland, TNN8973VOcean Flyers LLC · Chatham, NJN8973WPlasek Christopher · Owatonna, MNN8973YAire Ryder LLC · Roseville, MNN8974P4papa LLC · Gig Harbor, WAN8974WRassmussen Troy · Fayetteville, NCN8975VMauser James E · Zionsville, PAN8976Bouchard Paul Marcel · Yellville, ARN8976DWilliams Aircraft LLC · Anchorage, AKN8976JGreat Plains Aviation LLC · Lincoln, NEN8976YAfricano Aircraft Management LLC DBA · Chicago, ILN8977DWilliams Aircraft LLC · Anchorage, AKN8977JJohnson Bradley F · West Babylon, NYN8977PWarrior Up LLC · Clayton, NCN8977RCozine Mark R · Cherokee, IAN8977WRice Elden · Black Hawk, SDN8978DShuman Cecil R Trustee · Chugiak, AKN8979DBurnett Kris W · Anchorage, AKN8979MBean George W Jr · Fort Worth, TXN8979NPeeling Clyde R · Allenwood, PAN8979PShortridge Mary E · Bennet, NEN8979RSeeley Lenard D · Osage, WYN8979VAvel Aircraft Inc · West Chicago, ILN897ALJansky Sand & Gravel Inc · Hallettsville, TXN897DCRed Baron LLC · Middletown, DEN897DSHolliday Richard A · Fort Worth, TXN897ECMatacia Thomas Eugene · Evergreen, NCN897GArcher Flight LLC · Wilmington, DEN897GAPruim Bradley · Dorr, MIN897HParagon Flight Training Co · Fort Myers, FLN897JSMurray James P · Parrish, FLN897JWAmh Properties LLC · Auburn, ALFirst renewal noticeN897MGlenn David H · Big Lake, AKN897MAPate Jimmy B · Fredericksburg, TXN897MBJts Aircraft LLC · Rock Hill, SC
Back to AD 87-10-06 R1