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.
N5878MKodiak Helo LLC · Kodiak, AKN58BJJmp Aviation Corp · Dover, DEN58JASunergy Solutions LLC · Londonderry, NHN5910MCross Country Well Service LLC · Farmington, NMN592GCFogelson Robert A · Tillamook, ORN5931MSteven F Danz LLC · Encino, CAN5938MKarlen John R · Boring, ORN594BVJmak Corp · Seymour, TNN5CGSamair LLC · Blackshear, GAN5HEFinancial Solution Services · Leesburg, FLN60DMDatom Inc · Culver City, CAN60EDawson Aircraft Inc · Clinton, ARN60PPJaams LLC · Shafter, CAN60WHSan Clemente David Paul · Edgewater, FLN612JRQ & A Company LLC · Newport, RIN615PCBurning Blue LLC · Greenwood, MSN615PJEngelstad Dana P · Midland, TXN615SALordemann Holdings LLC · Kalispell, MTN618MROshaughnessy Stephen M · Littleton, CON61DDKissner Mark E · Frederick, MDN61WWKingsboro David · Menifee, CAN6219CAbbott Todd Christopher · Houston, TXN6221CSahuaro Enterprises Inc · Moreno Valley, CAN6225XN6225x LLC · Henderson, TNN6228XMad Doog Aviation LLC · Kalispell, MTN6240XCoal Black Cattle Co LLC · Roundup, MTN6258NTango Victor Aviation LLC · Kingsburg, CAN6269NJuliet Tango Capital LLC · Saginaw, MIN626HMRb Aviation LLC · Tyler, TXN6276XWj Bolton Farms LLC · Mark Tree, ARN628RKNicholas Adam J · Loomis, CAN6290NShrauner Reid · Elkhart, KSN6292NAvjets LLC · Miami, FLN6297XMike Sierra LLC · Brookings, SDN6301XRonald A Peterson Inc DBA · Orlando, FLN6303XNelson Stephen C · Niwot, CON6304XAndriopulos Salguero Inc · Hialeah, FLN6305XMurray Co · Compton, CAN630PLSaratoga Homes Of Texas San Antonio LLC · El Paso, TXN6311XMatts Cats LLC · Osceola, WIN6316XLear Traase Kj · Roundup, MTN6319XWilliver Troy Lyn · Sherwood, ORN636BTWestwind Digital Corp · Mahwah, NJN636KKKnox Construction Inc · Verdi, NVN63ECAugend Arsalan · Chicago, ILN63ENEcho November Inc Trustee · Wilmington, DEN64KTKlute Jordan · Omaha, NEN651DBJgm Icarus LLC · Centennial, CON653JRMosquito Air LLC · Lewes, DEN6582Phoenix Aviation LLC · Bonaire, GA
Back to AD 81-07-11 R1