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.
N2801RSummers Clinton D · Maysville, NCN2802TRandolph Clint · Bullhead City, AZN2807RHayzan Aviation LLC · Wilmington, DEN280DABouffard Marcel · Flowery Branch, GAN280NDPlane Nonsense Inc · Middletown, DEN2810TBoudreau Robert D · Rusk, TXN2811MSale Reported · Rio Grande City, TXSale reportedN2811RLantz Raymond J · Huntington Beach, CAN2815MEd Hamilton Investments Lc · Richmond, TXN2816RBipes Anthony G · Forest Lake, MNN2817RHunt Loren M · Nevada, MON2819FMacair LLC · Kennesaw, GAN281CAFarrugia Joe · Cleveland, TXN281NDPlane Nonsense Inc · Middletown, DEN2820DAbdullah Ibrahim M · Las Vegas, NVN2823TAircraft Restoration LLC · Valparaiso, INN2824DSchaible John A · Moneta, VAN2824YForbes Aviation LLC · Boise, IDN2825KHigh Flying Club Inc · Fort Wayne, INN2825TBeatty Daniel H · Bronx, NYN2826TKochersberger Kevin B · Blacksburg, VAN282NDMoore Aviation Inc · Beaver Falls, PAN2831TMesiemore Roger · Lake Wylie, SCN2832TKirtland Air Force Base Aero Club · Kirtland Afb, NMN2835NDelsair Inc · Maitland, FLN2837UCamous Alain E · Sunrise, FLN2839YTurbo Arrow LLC · Fresno, CAN283PAGeorge'S Aviation Services Inc · Honolulu, HIN2841RMoses Aviation Services LLC · Uvalde, TXN2842TStacey Daryl · Belton, TXN2842YRocky Road Aviation LLC · Ruskin, FLN2844ML C C West LLC · Freehold, NJN2844RBower Robert W · Scottsdale, AZN2846YDasher Richard Allan · Keystone Heights, FLN2847UFlow Building Solutions LLC · Cartersville, GAN2847XTurner Wayne S · Parkland, FLN2848MPumarol Rafael · Homestead, FLN2849TBlue Raven Aviation · Shady Cove, ORN2850TKolu Pilots Flying Club LLC · Columbus, NEN28514Diuguid II LLC · Ghent, KYN2853JSanvoisin Fabio · Las Vegas, NVN2853NBosque Raul E · Ocala, FLN2853SCastle Joseph E · Marietta, OHN2855MCutler Jeffrey R · Columbus, INN2857XWalton Wade · Downingtown, PAN2858KRalston Jared S · Kyle, TXN285AAGoldrock Aviation LLC · Princeton, NJN285MGGeorgia Aviation Authority · Eastman, GAN2861TDesert Sky Flight Group Inc · Tucson, AZN2862TReed Thomas F · Maize, KS
Back to AD 82-06-11 R1