AD 81-13-12 R1
Registered aircraft · 562
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-13-12-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:81-13-12-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:81-13-12-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:81-13-12-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.
N660HAHelicopter Applicators Inc · Gettysburg, PAN67231United States Army · Ft Rucker, ALFirst renewal noticeN681HBCity Of Huntington Beach · Huntington Beach, CAN682HBCity Of Huntington Beach · Huntington Beach, CAN683HBCity Of Huntington Beach · Huntington Beach, CAN684AEAir Evac Ems Inc · O Fallon, MON69FHelicopters Inc · Cahokia, ILN6NJNew Jersey State Police · West Trenton, NJN6QPHelicopters Inc · Cahokia, ILN6TYMooney Seven Inc · San Antonio, TXN705FSHvl Construction Inc · Fresno, CAN70606Registration Pending · Rome, NYRegistration pendingN711TTFaithful Flyers LLC · Lakeside, CAN712MScotts Helicopter Service Inc · Le Sueur, MNN713WRTrans Texas Helicopter Transport LLC · Realitos, TXN7159HPremier Rotors LLC · Saint Martinville, LAN71HMSummit Helicopters Inc · Salem, VAN71JJInterstate Helicopters Inc · Bethany, OKN721KHBruce Mike · Evadale, TXFirst renewal noticeN7266KGulf Helicopters LLC · Santa Fe, TXN726HGm Leasing Company LLC · Broussard, LAN727JSTrickett Michael W · Washington, DCN729AEAir Evac Ems Inc · O Fallon, MON73AWTre Aviation Corp · Wilmington, DEN73WLLaroche Aviation Services LLC · Bellaire, OHN7575SDkpa Heli LLC · Webster, MNN75TVMooney Seven Inc · San Antonio, TXN761MHMansfield Heliflight Inc · Milton, VTN762MHGm Leasing Co LLC · Broussard, LAN763MHGm Leasing Co LLC · Broussard, LAN765MHGm Leasing Co LLC · Broussard, LAN767HWeyerhaeuser Nr Co · Seattle, WAN769MHGm Leasing Co LLC · Broussard, LAN76LPPanther Helicopters Inc · Belle Chasse, LAN771KESchilling Michael K · Kenai, AKN772DWCcf Ventures Inc · Bangor, MEN775DWCosta James J · Prineville, ORN77DCOmega 377 Pennsylvania LLC · Shavertown, PAN782AEAir Evac Ems Inc · O Fallon, MON783AEAir Evac Ems Inc · O Fallon, MON785AEAir Evac Ems Inc · O Fallon, MON7860SMagnum Aviation LLC · Goff, KSN790RBRight Brother Aviation LLC · Rome, NYN7978KMowata Farms LLC · Mamou, LAN79TMAbove & Beyond Aviation Inc · Anchorage, AKN79TVBank Of Utah Trustee · Salt Lake City, UTN7QNHelicopters Inc · Wilmington, DEN7YJHelicopters Inc · Linden, NJN801CLAv8-Orr Helicopter Services Inc · Hamilton, MTN803BAWildwest Helicopters Inc · Henderson, NV
Back to AD 81-13-12 R1