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.
N711CBRoundhive Corp · New York, NYN711MLShuff James S II · Victor, WVN711SDMundy William L · Proctorville, OHN711YLBurkett Gary L Trustee · Murfreesboro, TNN712GLThere And Back LLC · Tulsa, OKN71LDLaney James R · Granbury, TXN721YGRunway Aviation Flight Training USA Corp · Rockwall, TXN728CTBerns Ridge Service LLC · Whittier, CAN72VTNot Enuf LLC · Jackson, WYN73EPColburn & Associates LLC · Woodruff, SCN740WJAlm Holding LLC · Winton, CAN74HJRegistration Pending · Sheridan, WYRegistration pendingN750PCMarilyn Merlot LLC · Kalispell, MTN7632QPremier Helicopters LLC · Carson City, NVN765JBN765jb LLC · Colorado Springs, CON765LTDrj Aviation LLC · Dover, DEN76WDLittle Evin M · Bidwell, OHN7719QTurel Stanley · Bend, ORN771MPFl072 Aviation LLC · Brentwood, TNN774DCBas Part Sales LLC · Greeley, CON7750QJohnson Gregory L · Orange, CAN77555Hmc Aero LLC · Ayer, MAN777DPittsburgh Institute Of Aeronautics · West Mifflin, PAN777NHS And S Airlink · Troy, MIN77BRInternational Air Services Inc Trustee · Carson City, NVN77QBDeauxboys LLC · Menomonee Falls, WIN7841QExigo Capital LLC · Miami Beach, FLN7845QReading Jared · Uvalde, TXN787GSwirsding David J · Chalfont, PAN788DMSts Aviation LLC · Daytona Beach, FLN789MD340a1021 Inc Trustee · Wilmington, DEN789SCTransport Drive Man LLC · Encino, CAN78SBas Part Sales LLC · Greeley, CON79ASPlane Fun Inc Tr Trustee · Snellville, GAN800BCN800bc LLC · Columbia, PAN800BGBlaikie Thomas B · Kenner, LAN802MCRunaway Plane LLC · Oklahoma City, OKN808TWVa Office Of Emergency Service LLC · Hampton, VAN812VLa Plane LLC · Fort Thomas, AZN814SWWenman Bradford Harris · Johnson, KSN8175QMillenium Enterprises LLC · Naples, FLN81RYRedding Dermatology Medical Group Inc · Redding, CAN822VWWetherbee Rodney A · Florence, ORN8237QAircon LLC · New Franklin, OHN824BCAonvo Investment LLC · North Miami, FLN825WBeckett Jesse · Lakeway, TXN82GBAmerican Aviation Inc · Page, AZN830BJElm III Operating Company LLC · Edmond, OKN830TTThuen Douglas · Andover, NJN83JBHuie Ag Service LLC · Beeville, TX
Back to AD 81-07-11 R1