AD 82-16-05 R1
Registered aircraft · 562
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-16-05-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-16-05-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-16-05-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-16-05-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.
N63730Central Virginia Aviation Inc · North Dinwiddie, VAN63TTBrothers Aviation Va LLC · Manassas, VAN642WAGunnslinger Air LLC · Destin, FLN64APD&N Holdingsinc · Boca Raton, FLN652PLN652pl LLC · Saint Joseph, MON65CMCapital City Jet Center Inc · Somerset, OHN660ACSmooth Air LLC · Richboro, PAN662CWPrecision Air Inc · Anchorage, AKN668CWPrecision Air Inc · Anchorage, AKN66AEAndreassi LLC · Bluffton, SCN66ATDeer Elm Aviation LLC · Owens Cross Roads, ALN66BGAlaska Island Air Inc · Togiak, AKN66TBTurner Brothers LLC · Middleboro, MAN676ARBlackdog Air LLC · Belton, SCN676SAVincennes University · Indianapolis, INN6890Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN696SGAtl Pilot LLC · Senoia, GAN697WHAgri Enterprises LLC · Hopkinsville, KYN698VWSheppard Louis A · Queens Village, NYN6ARBluewater Airmotive Corporation · Wilmington, DEN6GRMarc Inc · Bolton, MSN700CMoss Donald · Pinecrest, FLN703XPAircraft Guaranty Corp Trustee · Oklahoma City, OKN70543Tk Group Holdings LLC · Wilmington, DEN707HHT And L Restaurant Groups Aviation LLC · Hattiesburg, MSN709SAN709sa LLC · Maxville, FLN70FLFl Jet Services Inc · Miami Springs, FLN70HHAmys Aircraft Services LLC · Bridgeton, MON710DGNavajo Holdings LLC · Naples, FLN710JPSt Matthew Aviation Company LLC · Kalispell, MTN711MAKiddie Hawk Air Academy · Littleton, CON713WTWtw Air LLC · Houston, TXN71481Jib Inc · Groton, CTN715AJA&J Air Sales Inc · San Antonio, TXN7164DAir Arctic Inc · Fairbanks, AKN717UOcean Abaco LLC · Virginia Beach, VAN71LKChallenge Tool & Mfg Inc · New Haven, INN721CEErtel Thomas H · Charlotte, NCN722WCS & T Aviation LLC · Missoula, MTN723KYCommonwealth Of Kentucky · Frankfort, KYN725RWGalante Holdings LLC · Altamont, ILN727HBRiverside Farms · Sardis, MSN727MAMarc Inc · Bolton, MSN727RLHammerton Kenneth R · Olive Branch, MSN728CAPremiere Aviation Inc · Wilmington, DEN72LKN72lk Holding Company LLC · Coral Gables, FLN735QStuart Aviation Holdings LLC · Stuart, FLN737WKInternational Air Services Inc Trustee · Carson City, NVN73CZBm Air LLC · Anaconda, MTN73LKMoore David E · Stuart, FL
Back to AD 82-16-05 R1