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.
N2175FAircraft Trust Services Inc Trustee · Dover, DEN2176KLino Edson · Saugus, MAN2178KAbby Aviation LLC · Wilmington, DEN21870Tezaguic-Swanson Olga I · Wichita Falls, TXN2189NFlight Operations Academy LLC · Chandler, AZN218WGWilliams Sydney E · Kendallville, INN218WPGriffin Kurt J · Gardnerville, NVN2191LAir Leasing Service Inc · Hillsborough, NJN2194YDavid Shawn M · Roscoe, ILN2195LGinsberg Andrew P · Rochester, NYN2199HQualitair LLC Trustee · MichelstadtN21LKDalton Versel Jr · Fort Myers, FLN21PMDalelyn LLC · Claremont, NHN2202LMiles Edward A · Manteno, ILN2204TNgugi Samson W · El Paso, TXN2205HTango Alpha IV LLC · Highlangs Ranch, CON2206QVandeman Jack · Norco, CAN220MGCornwell Anne L · Athens, OHN2212DMichel David L · Greenville, SCN2214VJohr Bernardo M · Pembroke Pines, FLN2215QMoore Verba A · Biloxi, MSN2216QQualitair LLC Trustee · MichelstadtN2218ZArtisan Aviation Inc · Rochester, NYN2219ZSchneider Robert E · Hacienda Heights, CAN221SDKimball James R · Indian Trail, NCN2220ZMoore Norman H · Weston, CTN2223ZKliewer Gary D · Fort Morgan, CON2224ZSexhus Sanford C · Southlake, TXN2226TRegistration Pending · Tucson, AZRegistration pending, pending cancellationN222GAYoung Robert A · Cass, WVN222HBUniversal Aviators Academy Inc · El Monte, CAN222PTFme Aviation LLC · Wheelersburg, OHN222RACaptain Rick LLC · Miami Lakes, FLN222RSDawson Douglas L · Fernley, NVN2230QSchmidt John J · Pueblo West, CON223JDFlynt Kevin D · Decorah, IAN223WWSan Diego Flight Training Inc · San Diego, CAN2241NBell Michael C · Sammamish, WAN2242NSt Louis Flying Club Inc · Ellisville, MON2243NBarclay Alexander C · Seattle, WAN2243ZWashington Israel · Cincinnati, OHN2247MCamp Randall · Duncan, SCN2247WButts Alan R · Bismarck, NDN2247XElliott James F · Florence, ALN2248GClear Skies Aviation 1959 LLC · Boca Raton, FLN2248XSecond Life Properties LLC · Salisbury, MDN2249NPatzer Emmons M · Palmetto, FLN2249XElwood Andrew D · Essex, CTN224HSHenderson State University · Arkadelphia, ARN2250XValdes Manuel · Miami Beach, FL
Back to AD 82-06-11 R1