AD 82-06-11 R1
Registered aircraft · 2,375
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:82-06-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:82-06-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:82-06-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:82-06-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.
N2251MBelfiglio Brett N · Arroyo Grande, CAN2253MOgata Randy Lynn · Yuma, AZN225PACapitol Aircraft Inc · Wilmington, DEN2263QRoss Air Chicago LLC · Chicago, ILN2266MGraves Robert E · Danville, INN2272TNedley Nathan D · Georgetown, KYN2273TDevenezia Robert P · Brentwood, TNN2274THoller James F · Stuart, FLN2276MMuddy River Capital LLC · Glendive, MTN2277QComanche Aviation LLC · Chanute, KSN2279TRegistration Pending · Lakeville, MNRegistration pendingN2285QGandy John W III · Mount Vernon, TXN2286QRinker John W · Pontiac, ILN228NCIal Corp · Lewes, DEN228TXTexas State Technical College · Waco, TXN2292MShymkewich Dale G · Arlington, VAN2293MFines Aviation #1 LLC · Fargo, NDN2294QSouth Florida Helicopters Inc · Indiantown, FLN229DRSpecialty Veterinary Services LLC · Monteverde, FLN22HABig Bend Aviation LLC · Odessa, TXN22KSWhite Brian · Forsyth, GAN22RNTre Ventures LLC · Mount Olive, NCN22SRHillman Greg T · Riverside, CAN2308TBugarchich Christopher Z · Stratford, CTN2311TAlanair LLC · Red Hook, NYN2317TShirley Aviation LLC · Alexandria, VAN2325TFlorida State College At Jacksonville · Jacksonville, FLN2327TSale Reported · Hampton, GASale reportedN2328TElite Flight LLC · Lordstown, OHN2333TNottingham Jeffrey A · Locust Grove, GAN2334MSunrise Aviation Inc · Ormond Beach, FLN2336TN2336t Airplane Partnership LLC · Wilmington, DEN2339TK E F Enterprises Inc · Plymouth, MAN2340TGrillo Donald · Green Cove Springs, FLN2350MCampbell J Bryce · Stillwater, OKN2394MOld Buzzard Ltd · Columbus, OHN23LEMidstate Aviation 1 LLC · Owosso, MIN2411MAltshuler David · Cambridge, MAN2412MChristensen Broadcast Group Inc · Watertown, SDN2436MVenture Aviation Inc · Arlington, MAN243DWSijtsma Wouter · Ladson, SCN2448MSnider Robert Douglas Daniel · French Camp, CAN245DWJr Aircraft LLC · Dayton, OHN2464QWilson Jeff · White Bluff, TNN246JBN246jb LLC · Boynton Beach, FLN248BNEshleman James E · Yucaipa, CAN2495MPark Brian D · Springville, UTN2496MMorgan Jay · Fort Mill, SCN24SWDann Mark A · Utica, OHN2519MCoutcher Michael A · Belleview, FL
Back to AD 82-06-11 R1