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.
N421NCState Of North Carolina · Raleigh, NCN430BHBering Air Inc · Nome, AKN4376DPlanes Of Fame Air Museum · Chino, CAN43FKKaman Aerospace Corp · Bloomfield, CTN43HXHelicopter Express LLC · Chamblee, GAN444SJJones Flying Service · Biggs, CAN449RCCounty Of San Diego · El Cajon, CAN453CCHelo 1 LLC · Anchorage, AKN456TARoberts Aircraft LLC · Cheyenne, WYN474THTop Hand Inc · Laurel, MTN5073XMartins Dusters Inc · Colusa, CAN510WWBlades LLC · Arlington, WAN515Savauge Air LLC · North Las Vegas, NVN51AFEastern Stearman Inc Trustee · Leesburg, VAN526MWMountain West Helicopters LLC · Saratoga Springs, UTN530NCCopter Lease LLC Trustee · Albuquerque, NMN534HQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN534NCCopter Lease LLC Trustee · Albuquerque, NMN540FUAdf Helicopters Inc · Brewster, WAN549RLAircraft Trustee Services Inc Trustee · Dover, DEN574PDRegistration Pending · Arbuckle, CARegistration pendingN580SHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN58468Long-Line Leasing LLC · Saratoga Springs, UTN599HFNext Level Marine LLC · Mount Pleasant, TXN59HPHansen Albert C · Mojave, CAN606HFAgriforrestal Applications Inc · Cape Coral, FLN610WWBlades LLC · Arlington, WAN61650Great Falls Property LLC · Auburn, MEN6180AJones Aviation Inc · Biggs, CAN6257PPremier Aircraft Services LLC · Bakersfield, CAN6261CVi1 LLC · Brewster, WAN62767Aquila Helicopters LLC · Elliston, MTN638HAHelicopter Applicators Inc · Gettysburg, PAN64770Premier Aircraft Services LLC · Bakersfield, CAN648HAHelicopter Applicators Inc · Gettysburg, PAN661UHRegistration Pending · Midlothian, TXRegistration pendingN669HV2plus 1 LLC · Homer, AKN66HJEcho Foxtrot Holdings LLC · Lewes, DEN674THTimberline Helicopters Inc · Sandpoint, IDN675THTimberline Helicopters Inc · Sandpoint, IDN679HHillcrest Aircraft Co · Lewiston, IDN67FURotak LLC · Anchorage, AKN67NHState Of North Carolina · Raleigh, NCN67SHNorthwest Helicopters LLC · Olympia, WAN6828Northwest Helicopters LLC · Olympia, WAN689HHillcrest Aircraft Co Inc · Lewiston, IDN68ECCopter Lease LLC Trustee · Albuquerque, NMN7042LSouthwest Florida Aviation · Arcadia, FLN7042NAgriforrestal Applications Inc · Arcadia, FLN710WDA&P Helicopters Inc · Richvale, CA
Back to AD 97-07-05