AD 81-07-11 R1
Registered aircraft · 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-07-11-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-07-11-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-07-11-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-07-11-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.
N444JMPeck Joseph A · Pound Ridge, NYN444KTHangar G-1 Aviation Partners LLC · Los Olivos, CAN444KWRaw Racing Inc · Puyallup, WAN4515QEagle Holding Co LLC · Indianapolis, INN451PKMackenzie Matthew S · Sacramento, CAN4557NWestra Aviation LLC · Beaver Dam, WIN4568NBergren Scott W Trustee · Walnut Creek, CAN456JMLandmark Aviation Services LLC · Sarasota, FLN456WPMatagorda Production Co · Westhoff, TXN4577LLucas John · Norco, CAN4578NAviation International LLC · El Paso, TXN4579NSeven Eight Juliet LLC · Edmond, OKN457DMMajor Development LLC · Cedaredge, CON4589NGeneric Implant Solutions LLC · Pratt, KSN4599FCcs Flight Services LLC · Benton Harbor, MIN45TFWave Transportation LLC · Middletown, DEN4604NS O W Aviation LLC · Crystal River, FLN4674NBorderline Sky LLC · El Paso, TXN467DBParamont Services Inc · Newbury Park, CAN4754AIndigo Air LLC · Gulf Breeze, FLN47645Arizona Type Ratings LLC · Sedona, AZN47AGAircraft Guaranty Corp Trustee · Oklahoma City, OKN4833AEnoch Mark C · Rowlett, TXN486MHMh Group LLC · Duncan, OKN487KMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN500CTLac Aero LLC · Liberal, KSN500EBKaizen Aircraft Holdings LLC · Kalispell, MTN500QVJands LLC · Broken Arrow, OKN5013QTesini Allan J · Zephyrhills, FLN501DCExecutive Aviation LLC · Peoria, AZN5037QSayler Ben · Thief River Falls, MNN505SFLux William E · Newman Lake, WAN5061QLepper Michael J · Ward, CON5098QM&L Engine LLC · Schriever, LAN50GBOviedo Juan M III · Oak Point, TXN510TFLang Eric O · Oklahoma City, OKN512HPN512hp LLC · Dover, DEN513DWright Aero Inc · Saint Cloud, MNN5140JTruk Err Inc · Wilmington, DEN5151JHalverson Mechanical Inc · Ogden, UTN5157JApogee Finance LLC · Fort Worth, TXN515BTAir Safety Investigators LLC · Nokomis, FLN515DCmmk LLC · Talent, ORN5160JZemnickas William V · Metamora, MIN5163JQuantie Harold · Locust Grove, OKN5165JPeak Wings LLC · Missoula, MTN5169JPotter Kent W · Laurel, MTN5175JAycock Charles C · Midland, TXN5178JSeven Eight Juliet LLC · Edmond, OKN5181JForce One Inc · Missoula, MT
Back to AD 81-07-11 R1