AD 97-07-05
Registered aircraft · 187
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-07-05')
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-07-05')
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-07-05') 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-07-05') 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.
N210MAMinuteman Aviation Inc · Missoula, MTN211NWOlympic Jet Inc · Olympia, WAN212DFState Of Nevada · Reno, NVN216APA&P Helicopters Inc · Richvale, CAN216GHRotorcraft Support Inc · Fillmore, CAN217APCopter Lease LLC Trustee · Albuquerque, NMN223HTHillsboro Aviation Inc · Hillsboro, ORN2252APremier Aircraft Services LLC · Bakersfield, CAN225PRWindsock Management LLC · Little Rock, ARN22753Martins Dusters Inc · Colusa, CAN229HTVertical Corp · Kalispell, MTN232PJHelibro LLC · Red Bluff, CAN233LEArmy Aviation Heritage Foundation And Museum Inc · Hampton, GAN234SJPorter Flying Services Inc · Chico, CAN256KTKord Technologies Inc · Huntsville, ALN262RCUS Airlift Command Inc · Anderson, SCN264RMRocky Mountain Construction LLC · Klamath Falls, ORN2650NIaba LLC · Norfolk, VAN267KATimberline Helicopters Inc · Sandpoint, IDN2773HSummit Helicopters Inc · Salem, VAN283HFArmy Aviation Heritage Foundation And Museum Inc · Hampton, GAN284MMMarble Mountain Helicopters LLC · Roseburg, ORN28HXHelicopter Express LLC · Chamblee, GAN30111Sky Walker Aviation LLC · Indianapolis, INN304HALyons Aircraft Leasing LLC · Hillsboro, ORN3053QWest Valley Aviation Inc · Five Points, CAN313BNorthwest Helicopters Inc · Olympia, WAN314Central Copters Inc · Bozeman, MTN316LHLohman Helicopter LLC · Lewiston, IDN319WASky High Leasing LLC · Montrose, CON324MWMountain West Helicopters Of Montana LLC · Missoula, MTN3276KMooney Seven Inc · San Antonio, TXN333XLCj Air LLC · Nezperce, IDN334WNPope Jim D DBA · Lewiston, IDN33HXCopter Lease LLC Trustee · Albuquerque, NMN353RCN353rc LLC · Chelan, WAN357KAHeli 807 Leasing LLC · Anchorage, AKN3605Mann Peter D · Willows, CAN374PACopter Lease LLC Trustee · Albuquerque, NMN3803CState Of Colorado Department Of Public Safety · Lakewood, CON3804CState Of Colorado Department Of Public Safety · Lakewood, CON380PLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN39HXHelicopter Express LLC · Chamblee, GAN3XLNixon Helicopters LLC · Mentone, CAN4040PR & R Conner Aviation LLC · Conner, MTN404HAHillsboro Aviation Inc · Hillsboro, ORN406JPHeli-Works Flight Services LLC · Deer Lodge, MTN40722West Valley Aviation Inc · Five Points, CAN40HXHelicopter Express LLC · Chamblee, GAN41109Lrh Equipment LLC · Pendleton, OR
Back to AD 97-07-05