AD 80-25-01
Registered aircraft · 342
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:80-25-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-01')
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:80-25-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-01') 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.
N145ALQuicksilver Air Inc · Fairbanks, AKN150AGInternational Air Services Inc Trustee · Carson City, NVN151JPFarmar Peter D · San Angelo, TXN1578FHeliservice LLC · Wilmington, DEN160DAWehring Justin DBA · Clute, TXN161LAAir2 LLC · Blountville, TNN166MBHelicopter Roundup Service LLC · Nephi, UTN167ALFerguson And Sons Construction LLC · Emmett, IDN16QRegistration Pending · Fredericksburg, VARegistration pendingN17167Slade Aviation LLC · Carlsbad, NMN173ALFulton Timothy E · Salem, MON174ECBingham Larry F · Juneau, AKN175JLRatcliff Dustin · Saltville, VAN17801Mckee John R · Central Point, ORN187YMBrown Byron Tim · Hermiston, ORN191VSVertol Systems Co Inc · Destin, FLN192VSVertol Systems Company Inc · Destin, FLN193VSVertol Systems Co Inc · Destin, FLN194VSVertol Systems Company Inc · Destin, FLN195VSVertol Systems Co Inc · Destin, FLN196VSVertol Systems Company Inc · Destin, FLN2091RCity Of El Paso Police Department · El Paso, TXN212ELMark Mondo Building & Excavating Inc · Reno, OHN212VTLaroche Aviation Services LLC · Bellaire, OHN21772N21772 LLC · Wellington, FLN221TGCollier Mosquito Control District · Naples, FLN225HRHeliwild Investments LLC · Austin, TXN230MDAir2 LLC · Blountville, TNN240FLAir2 LLC · Blountville, TNN259BKCavanaugh Collections Inc · Addison, TXN262SDCullman Police Department · Cullman, ALN262WAWindward Aviation Inc · Puunene, HIN278KCCullman Police Dept · Cullman, ALN28MLTre Aviation Corp · Wilmington, DEN298SDCsw LLC · Anacoco, LAN301SDHarrison County Sheriffs Department · Gulfport, MSN3051QCharlie Helicopter Company LLC · Sierra Blanca, TXN305AZJta Express Inc · Wilmington, DEN305JEDah Aircraft LLC · Georgetown, SCN3121QC&D Helicopters LLC · Spanish Fork, UTN313JPPerell John · Miami Beach, FLN315SHJc Aircraft Leasing LLC · Wasilla, AKN316HKHawkeye Holdings LLC · Lyndon, KSN31HMDah Aircraft LLC · Georgetown, SCN330CMDewind Helicopter Services LLC · Zeeland, MIN332ABUsda Aphis Ws Atoc · Cedar City, UTN333TABallard Aviation Inc · Newton, KSN33TJRhk Of Kansas Inc · Overland Park, KSN348Bhh Leasing #2 LLC · Pensacola, FLN353AHBank Of Utah Trustee · Salt Lake City, UT
Back to AD 80-25-01