AD 82-16-08
Registered aircraft · 112
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:82-16-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-16-08')
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:82-16-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-16-08') 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.
N100ABLandry Camile J · Baton Rouge, LAN10CJZareefeh Christopher · Fairbanks, AKN12620Lapoint Paul E · Drummond Island, MIN142KYSchachle Robert Godfrey · Wasilla, AKN169ETerrell Joe W III · Anchorage, AKN173KWikle Artic C · Wasilla, AKN18JCWinged Vision Incorporated · Gaithersburg, MDN2267ZHanneman Logan L · Fairbanks, AKN242BClark Kyle B · Underhill, VTN289LMHawkins Lynn A · Franktown, CON295BFChestnut Aviation LLC · Sisters, ORN295DGCoplin Christopher S · Anchorage, AKN295FWWilliams Lane · Wasilla, AKN295GCMeternet Mt LLC · Polson, MTN295HRapoport R Michael · Seldovia, AKN295HCChad Inc · La Jolla, CAN295LAN93pf LLC · New York, NYN295SMCornice LLC · Fairbanks, AKN295XXJames Jeffrey L · Elizabeth, WVN29RAvian Air LLC · Anchorage, AKN300FTKokkonen Matt T · San Luis Obispo, CAN300LDJones Clayton S · Kalispell, MTN320LMBurton Richard D · Anchorage, AKN333TBMiller Byron W · Silverton, ORN395CBlydenburgh Daniel R · Wasilla, AKN395DGHannaman Cody Jay · Wasilla, AKN395HSouth Air Aviation LLC · Huntsville, ARN395HCLofstrom Caleb J · Wasilla, AKN3XVPeachey Virgil E · Maunaloa, HIN40TDobel Robert F II Trustee · San Carlos, CAN4119DTomanica Jack L · Nunica, MIN4120DClark Kyle B · Underhill, VTN4121DRegistration Pending · Weirsdale, FLRegistration pendingN4123DThun Karl J · Graham, WAN4138DCargill Stephen A · Vacaville, CAN4139DPerry Jim · Monroe, WAN413MMDoyle Brian G · Westfield, MAN4150D69ok LLC · Fairland, OKN4160DThompson Johnny J E · Coppell, TXN4164DWalker Richard J · Wasilla, AKN4195DAvian Air LLC · Anchorage, AKN42013Flynn Aviation LLC · Girdwood, AKN42GTThun Karl · Graham, WAN4431UDechert Barry E · South Rockwood, MIN44344Alaska Outdoor Consultants LLC · King Salmon, AKN461FMJaars Inc · Waxhaw, NCN47055Rhyneer George D · Eagle River, AKN5072KUnivest Aviation LLC · Scottsdale, AZN5072QBuzby Brian J · Wasilla, AKN528LMRemote Homes LLC · Anchorage, AK
Back to AD 82-16-08