AD 82-06-11 R1
Registered aircraft · 2,376
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.
N924JCCroman Graham P · Clayton, GAFirst renewal noticeN92605Sarratt Curtis H · Annapolis, MDN9262CRick Aviation Inc · Newport News, VAN9266KRestrepo Aircraft Corp · Fort Lauderdale, FLN926JMBlue Horizon Performance Inc · Kellogg, IAN9274NOkuda Hideki · Rncho Pls Vrd, CAN927KRCandace A Larned Enterprises Inc · Long Beach, CAN9290CMym Air LLC · Pattison, TXN9290KArrow Leaseback LLC · Danbury, CTN92DADelory Dana E · Shoreacres, TXN92GMPeri Joseph · Thorntown, INN92UATaylor Aviation Inc · Montgomery, NYN9301NAnderson Robert · Tonopah, AZN930RJN147sb LLC · Cortland, NYN9310NApproach Partners LLC · Franklinton, NCN9311NAmendt Joseph J III · Plymouth, MNN9315NDiir County Flying Inc · Sturgeon Bay, WIN931FSM & M Aviation Services Ltd · Rock Falls, ILN9320NEagle Aviation Inc · Tucson, AZN9321CBas Part Sales LLC · Greeley, CON9321NRegistration Pending · Shreveport, LARegistration pendingN9323CHangar 9 Inc · Aberdeen, SDN9328KSantoro Alexandre Jose · Mountain View, CAN9329NWang Huafei · Cupertino, CAN9332NSloan Donald W · Dover, DEFirst renewal noticeN9333NGlendale Community College · Glendale, CAN9334NRoberson Ronald M · High Ridge, MON9337NHoward Robert L · Jacksonville, NCN9338NForker Thomas S · Williamsport, PAN9340N9340n LLC · Broken Arrow, OKN9347NDavis Braeden L · Blanchard, OKN9348NPletcher Gayle L · Topeka, KSN9349NStutzman Gary A · Watsontown, PAN9350KPanjab Aviation · Las Vegas, NVN9351NHess Garrett J · Fullerton, CAN9354NThurnau Daniel E · Kingston, ILN9359NMorristown Flying Service Inc · Talbott, TNN9362CThanheiser Heige · Lincoln, NEN9362NPool Busters LLC · Lake Bluff, ILN9363NWeiman William R · Howell, MIN9368NSocal Resorts LLC · Big Bear Lake, CAN9370NWings Over Texas Holdings LLC · Denton, TXN9371NTial Aviation Inc · Wilmington, DEN9372NAndys Auto Sales LLC · Caroline, WIN9373NNelson Charles D · Wibaux, MTN9375NProffitt Albert E III · Warwick, RIN9377CLiggett Services Inc · Fort Washington, PAN9379NWinick Evan · Allentown, PAN937DCCaledonian Aviation LLC · Raleigh, NCN9380CKillion Jerry · Lubbock, TX
Back to AD 82-06-11 R1