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.
N5042TWells Thomas R · Chicago, ILN5051SCall Of The Loon LLC · Missoula, MTN5052SWonnacott Dereck · Auburn Hills, MIN5053SAviation Capital Management LLC · San Jose, CAN5054SWoodson Billy R · Elon, NCN5055SBattaile Jesse K · Chevy Chase, MDN5055TArrow 5055t LLC · Saint Helena, CAN5060TAirzona Aircraft Services Inc · Kingman, AZN5061TSullivan Patrick James · Avery, CAN5063SLancon James B · Prescott, AZN5066TLee Miesner Aviation LLC · Park Hills, MON5067SSinatsch Christian C · Saint Augustine, FLN5069SMccarron Michael · Cary, ILN506CJMatthews Joseph R · Bartlett, TNN5081SDream Factory Aviation Inc · Henderson, NVN5083SRiser Air LLC · Stillwater, MNN5085SHall Thomas K · Beaufort, NCN5086SAero Air Inc · Salt Lake City, UTN5088SSwaz Aviation LLC · Mesa, AZN5090SSturm Neal M · Randolph, NJN5094SBoraam Aviation Inc · Prospect Heights, ILN5098SBadenhope John R · Greeneville, TNN509DBMaycroft David E · Cary, ILN5100THaynes Michael H · Anniston, ALN5101SWaddill John W · Houston, TXN5107SJdc Aviation LLC · Upland, CAN5107TIron Horse Leasing LLC · Platteville, WIN510DROriley Rickalan H · Encino, CAN510TEPluid Darwin D · Eureka, MTN510THRegistration Pending · Oxford, CTRegistration pendingN5114SConner W Larry · Los Lunas, NMN5115SBridgeport Flying Club LLC · Bridgeport, CAN5124SCalvert David · Livermore, CAN5125SSlade Clark K · Pinckney, MIN512CSR Scott Hoffman/Silverado Transportation LLC · Kalispell, MTN5131SForan Dana Francis · Bement, ILN5142SRossow Eldon F · Fort Dodge, IAN5145SElsea Inc · Circleville, OHN5149SPiper Aircraft Inc · Vero Beach, FLN5163MUniversity Of Illinois · Savoy, ILN518MWUrban Kenneth J · Foxboro, MAN519RGRegistration Pending · Kokomo, INRegistration pendingN51WEColumbia Asset Trust Corp Trustee · Wichita, KSN5201TOwen Richard D · Ridgecrest, CAN5202TBartella Eric A · Canastota, NYN520ARSchool Of Missionary Aviation Technology · Ionia, MIN5210T51st Aero Squadron LLC · Hoover, ALN5217TJahangiri Ali · Arlington, TXN5225THolt Joseph · Farmington, MON5229TParker Edward Milton Jr · Griffin, GA
Back to AD 82-06-11 R1