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.
N251BCBearce Larry J · Solon, IAN2530MHoward Robert Thomas · Palmdale, CAN2556QDuan Yutao · Walnut, CAN2576MEsposito Joseph Salvatore · Jacksonville, FLN2588QDlp Ventures LLC · North Platte, NEN258SBSkyfusion II LLC · Atlanta, GAN2590QConant Edward · The Woodlands, TXN2597UBelisle Johnny E · Camden, TNN25ELPorcine Aviator LLC · Charlotte, NCN2601RHarden Aviation LLC · Washington, PAN2606UJanovyak Aviation LLC · Lockport, ILN2607RSullivan Christopher · Duson, LAN2610RStable Aviation LLC · Eagan, MNN2611MOlsen Robert F · Chatham, MAN261EZZokpodo Emmanuel K · Sacramento, CAN262XPrice Scott K · Sparks, MDN2634RRichardson Michael T · Inver Grove Hghts, MNN2672Q4m Aviation LLC · Orting, WAN2696RBowen Diane M · Newbury, MAN2697MCmp Aviation LLC · Williamsville, MON2698MBearce Larry James Jr · Solon, IAN26JTBohning Aviation LLC · Ponchatoula, LAN2702RBas Part Sales LLC · Greeley, CON2703RWorthington Gary M · West Berlin, NJN2704RStratus Equity LLC · Helena, MTN2705RCenterline Aviation LLC · Nolensville, TNN2707RCsc Delaware Trust Co Trustee · Wilmington, DEN2712RSimply Living LLC · Fort Myers, FLN2719CBrown Kevin Charles · Round Rock, TXN2719RJenkins Bruce D · New Market, MDN2722RPerez Angel L · Arecibo, PRN272LCPen And Pilot Inc · Flagler Beach, FLN2733RPatrick Barb · Farmer City, ILN2739RPerrong Andrew R · Huntingdon Valley, PAN2740RRegistration Pending · Wilmington, DERegistration pendingN2742RCollinsworth Frederick W · Broken Arrow, OKN2744MCas Aviation LLC · Warwick, RIN2746QArrow Three LLC · Orlando, FLN2759RFord William(Bill) A III · Abilene, TXN276MGGeorgia Aviation Authority · Eastman, GAN2770RHayward Flight LLC · Hayward, CAN2779MFuist Richard · Lake City, FLN277MHEuroaviation Inc Trustee · KematenN2781RBurley Robert L · Alliance, OHN2784QMaulhardt Lynn Edward · Oxnard, CAN278NDRegistered aircraftN279NDSowela Technical Community College · Lake Charles, LAN279SRMetro Aircraft Co · Bloomington, MNN27GSMazzola Michael · Baton Rouge, LAN27WMHeidebrink Ronald E · West Chester, OH
Back to AD 82-06-11 R1