AD 97-15-08
Registered aircraft · 525
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:97-15-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-15-08')
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:97-15-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-15-08') 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.
N131NWEmerald City Aircraft Leasing Inc · Port Orchard, WAN138TXAir2 LLC · Blountville, TNN13KJCarlston Carl Vaughn · Murray, UTN145ALQuicksilver Air Inc · Fairbanks, AKN151JPFarmar Peter D · San Angelo, TXN155NRState Of Minnesota · Grand Rapids, MNN1576FCity Of Houston Police Dept · Houston, TXN1578FHeliservice LLC · Wilmington, DEN15THHeliservice LLC · Wilmington, DEN16002Commonweath Of Massachusetts · East Boston, MAN1602LSaxton Helicopter Leasing LLC · Plymouth, MIN1604ZDept Of Fish Wildlife And Parks · Helena, MTN16050Venturi Aviation LLC · Missoula, MTN1605KCounty Of Gwinnett Georgia · Lawrenceville, GAN16062Flight Inspection LLC · Springdale, WAN16069Paragon Air Group · Fort Worth, TXN1610BBlackstead Investments Inc · Boise, IDN161LAAir2 LLC · Blountville, TNN163LHeli Fly Inc Trustee · Wilmington, DEN165HMidvale Air Research LLC · Lewes, DEN166MBHelicopter Roundup Service LLC · Nephi, UTN167ALFerguson And Sons Construction LLC · Emmett, IDN16EYCarleton Inc Trustee · Wilmington, DEN173ALFulton Timothy E · Salem, MON175JKJk Aviation LLC · Kerman, CAN175JLRatcliff Dustin · Saltville, VAN1808Gwinnett County Police Dept · Lawrenceville, GAN18CPPeoples Properties LLC · Tucson, AZN18FFHeliservice LLC · Wilmington, DEN18GHCity And County Of Honolulu · Honolulu, HIN193VSVertol Systems Co Inc · Destin, FLN195VSVertol Systems Co Inc · Destin, FLN199FFHeavy Lift Helicopters Inc · Fresno, CAN19FFHeliservice LLC · Wilmington, DEN20ATFlight Trails Helicopters Inc · Mesa, AZN20FLLocker Fred · Muleshoe, TXN212ELMark Mondo Building & Excavating Inc · Reno, OHN212VTLaroche Aviation Services LLC · Bellaire, OHN215MBunn Mary E · Williamstown, WVN220PDCity Of Oakland · Oakland, CAN221TGCollier Mosquito Control District · Naples, FLN225HRHeliwild Investments LLC · Austin, TXN228KKKeagy Ken · Central Point, ORN229HLAviation Advantage Inc · Tabor City, NCN230MDAir2 LLC · Blountville, TNN234RFMhoc LLC · Pensacola, FLN240FLAir2 LLC · Blountville, TNN241JHChatham County Mosquito Control · Savannah, GAN262WAWindward Aviation Inc · Puunene, HIN28MLTre Aviation Corp · Wilmington, DE
Back to AD 97-15-08