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.
N33599A & Aviation LLC · Pinellas Park, FLN33642Smith Gary E · Des Moines, IAN33663Brown Tony Mac II · Bowling Green, KYN33668Northeast Cubs LLC · Wilmington, DEN33684Coletti John · Grant Park, ILN33685Leighty Brian D · Dighton, KSN33698Briggs Michael L · Howell, MIN33720Westerhold Wayne · Cary, NCN33733Swink Cory A · Gold Hill, NCN33750Geek Air LLC · Wilmington, NCN33759Flight Time Club LLC · Searcy, ARFirst renewal noticeN33770Bassett Christopher D · Robbinsville, NCN33795Coco Phillip J · Middletown, CTN33804Klintrin Collectibles LLC · Downers Grove, ILN33815Hyde Leasing LLC · Water Valley, MSN33816Hettinger John E · Sterling, CON33849Sanzaro Aero LLC · Bunnell, FLN33863N318bm LLC · Monroe, LAN338672 F LLC · Valentine, NEN338PAFl Ventures I LLC · Winter Park, FLN3397QMills Ronald S · South Jordan, UTN339DALink Aviation LLC · Eau Claire, WIN33CLBills Jacqueline Trustee · Willard, MON33EGHoug David M · Pigeon Forge, TNFirst renewal noticeN33ESDuncan Ernest Michael · Dripping Springs, TXN33KVWild Blue Aero LLC · O Fallon, ILN33TGPiper LLC · Crystal Lake, ILN3405MSpectrum Exploration LLC · Jacksonville, TXN3420QBalladares Charles V · Mandeville, LAN3423QTrebs Adam · Tucson, AZN3433QGhamari Seyavosh · Irvine, CAN343WPPapa LLC · Eufaula, ALN3449MCarhart Thomas M · Galesville, WIN344ACInternational Air Services Inc Trustee · Carson City, NVN345CQTriple L Airways Inc · Pittsford, NYN3464QMac Air Inc · Farmington, MON3467QHawthorne Mark · Flagstaff, AZN3488MStrand Laird W · Appleton, WIN34DSMachado Rocha Conrado · Aventura, FLN34PTJentone Aviation LLC · Aber Prov Grd, MDN3511TTippett Daniel W · Heath, OHN3514MCooley David Alan · Harrod, OHN3543MConnor Michael B · Antioch, TNN354JHArrow Group 5 LLC · Lake Saint Louis, MON3554MWacker Peter K · Marietta, GAN3559MMoyer Josiah E · Paradise, PAN355AJTexas Flyers LLC · Amarillo, TXN3560MBeyond Grateful LLC · Frisco, CON35611Schutte Farm Inc · Burlington, CON35636Carreno Miriam · Portland, OR
Back to AD 82-06-11 R1