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.
N2708TCae Aviation LLC · Peshtigo, WIN2708YWings Aircraft LLC · New Richmond, WIN2709BA&R Investments Inc · Sylvania, OHN2709RSchultz Daniel A · Tipp City, OHN2710JPeople Incorporated Of Virginia · Abingdon, VAN2711NMountain Air Aviation LLC · Fruit Heights, UTN2742HWilbert John W III · Plaquemine, LAN2744PTouchdown LLC · Pls Vrds Est, CAN2744YDe Vuyst Richard C · Pampa, TXN2745FAlexander Production Co · San Antonio, TXN274DCMaggie 288 LLC · Quincy, WAN275RMRodgers Kenneth · Appleton, WIN27BGGuzman Steven Manuel · Port Saint Lucie, FLN28913Bellas Business LLC · Kalispell, MTN28LVCactus Clover Inc · El Paso, TXN2920GStevenson Taylor A · Dallas, TXN29BEAltaii Ali · Gibraltar, MIN2CFKentucky Aviation Solutions LLC · Frankfort, KYN304JWVega Air LLC · Pigeon Forge, TNN306TBApex Aviation Holding LLC · Kalispell, MTN30HBN30hb LLC · North Miami, FLN311KMDream Flight Florida LLC · Wellington, FLN3127TSouth Valley Internet Inc · San Martin, CAN314GRVice One LLC · Las Vegas, NVN314MGSummit Aviation LLC · Las Vegas, NVN320RMRd Harrison Inc · Lexington, NCN321RPIsrael Oscar M III · Sinton, TXN327TALeblanc Joseph E Jr · Houston, TXN32VSpeer Aviation LLC · Evansville, INN32VSCraftline LLC · Delray Beach, FLN330MRJett Aviation LLC · Clovis, NMN3333MFun Tickets LLC · Manchester, MEN333UDSpecialty Aero LLC · Seattle, WAN335DDJab Aviation Inc · Wilmington, DEN335KHSerafini Transportation LLC · Ringwood, NJN335PCOcow LLC · Jenks, OKN335PW335 Leasing LLC · Englewood, CON335SMMf Property Management LLC · Hattiesburg, MSN335TJYork Michael · Reston, VAN335TSHague Neil C · Wichita, KSN33HLKnudsen Russell G · East Troy, WIN33LFJbo Airventures LLC · Saint Petersburg, FLN3407CK&L Leasing And Investment LLC · Mountain Green, UTN340ABBison Investment Advisors Inc · Lafayette, INN340ADN89vy LLC · Benson, NCN340AGRicker David · Conway, ARN340AHEden On Broad LLC · Cookeville, TNN340AJListo Aviation LLC · Chelsea, ALN340ALPellair LLC · Bellingham, WAN340AMPrincess Aviation LLC · Missouri City, TX
Back to AD 81-07-11 R1