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.
N7177LSale Reported · Punta Gorda, FLSale reportedN7177POverstreet Robert S · Clarksville, VAN7177QLeonard William K · Seattle, WAN7177RSandifer Darian A · Speedwell, TNN7178KPavlus Igor V · Wasilla, AKN7178LRi Flying Club Inc · Fullerton, CAN7178MCiolkosz Ryan · Anchorage, AKN7178PN9271p LLC · Pahrump, NVN7178QSkylens LLC · Hammond, LAN7178UBell Construction Inc · Napa, CAN7178VUhl Jack G · Bloomington, MNN7178WSnyder Michael P Jr · Reno, NVN7179BBue B G · Palmer, AKN7179DLeggett Bryce L · Eola, TXN7179PHedgpeth H Brent · Bothell, WAN7179RIfly Aviation LLC · Ephrata, PAN7179WSummit Concepts LLC · Five Points, ALN717ACKcd Aviation LLC · Tonica, ILN717ARJones Joshua W · Hudson, MAN717BMMitchell Matthew S · Timnath, CON717BSTla Inc · Middletown, DEN717BYWhite Kenneth · Rancho Cordova, CAN717CAScott Henry Bach · Yakima, WAN717CEHuffman Jacob M III · Burleson, TXN717CPCivil Air Patrol · Montgomery, ALN717DBJohnston David M · Elwood, INN717ERippeto David P · Anchorage, AKN717FGRidgeline Assets LLC · Wilmington, DEN717FLNorth Texas Aeronautics LLC · Burleson, TXN717FTMurtha Ronald A Jr · Sycamore, ILN717HCLeading Edge Leasing LLC · Wilmington, DEN717HQArwen Evenstar LLC · Wilmington, DEN717JDKerr Ryan R · Mora, MNN717LULiberty University Inc · Lynchburg, VAN717LVPage Wayne N · Corning, IAN717MXBailey Steven W · Puyallup, WAN717NARegistered aircraftN717PRRensink Paul S · Battle Ground, WAN717PZThompson Helicopters LLC · Uvalde, TXN717RFWings Flight Enterprises Inc · Danville, KYN717RLDouble Rainbow Aviation LLC · North Fort Myers, FLN717SThornapple Flying Academy LLC · Middleville, MIN717SRStevens Christopher J · Galena, OHN717TATwin C Aviation Inc · Chapel Hill, NCN717THOhio State University · Columbus, OHN717TSStranak Thomas · Waukesha, WIN717VCCalo Robert V · Frederick, MDN717VTN717vt LLC · Wayne, PAN717WBFly Jive Fly LLC · Lake Wales, FLN717WJJohnson Warren G · Greer, SC
Back to AD 81-18-04 R2