AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N8973WPlasek Christopher · Owatonna, MNN8973YAire Ryder LLC · Roseville, MNN89743Heavy Metal Air LLC · Farmingdale, NYN8974P4papa LLC · Gig Harbor, WAN8974WRassmussen Troy · Fayetteville, NCN89753Aerohead Planes LLC · Savannah, GAN8975VMauser James E · Zionsville, PAN8976Bouchard Paul Marcel · Yellville, ARN89764South Aero LLC · Albuquerque, NMN8976CPetruso Rosemary D Co-Trustee · Saint Louis, MON8976DWilliams Aircraft LLC · Anchorage, AKN8976JGreat Plains Aviation LLC · Lincoln, NEN8976YAfricano Aircraft Management LLC DBA · Chicago, ILN89770Seals Richard W · Torrance, CAN8977DWilliams Aircraft LLC · Anchorage, AKN8977JJohnson Bradley F · West Babylon, NYN8977LSarigul Klijn Nesnn · Dixon, CAN8977RCozine Mark R · Cherokee, IAN8977WRice Elden · Black Hawk, SDN89780Huffman Jacob M III · Burleson, TXN8978CMenke Clint A · Cozad, NEN8978DShuman Cecil R Trustee · Chugiak, AKN8979DBurnett Kris W · Anchorage, AKN8979MBean George W Jr · Fort Worth, TXN8979PShortridge Mary E · Bennet, NEN8979RSeeley Lenard D · Osage, WYN8979VAvel Aircraft Inc · West Chicago, ILN897ALJansky Sand & Gravel Inc · Hallettsville, TXN897ATCxk1 LLC · Wilmington, DEN897CPCivil Air Patrol · Maxwell Afb, ALN897DCRed Baron LLC · Middletown, DEN897DSHolliday Richard A · Fort Worth, TXN897ECMatacia Thomas Eugene · Evergreen, NCN897EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN897GArcher 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, SCN897NDUnd Aerospace Foundation · Grand Forks, NDN897RVPorter David T · Martinsburg, WVN897SCPeregrine Howard Partners II Lp · New Orleans, LAN897SMDomich Jeffrey E · Petaluma, CAN89800Ballesteros Irlena · Glendale, CAN8980RHolmes Aviation Inc · Cannon Falls, MNN8980VSweitz-Air Inc · Stewartstown, PAN8980WAddis Timothy David · Mount Vernon, OH
Back to AD 81-18-04 R2