AD 2009-15-13
Registered aircraft · 168
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:2009-15-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-15-13')
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:2009-15-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-15-13') 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.
N510WWBlades 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, IDN6828Northwest 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, CAN714MQHaus Michael D · Concord, CAN730VBAsa Security LLC · Anchorage, AKN737HFSpitfire Ventures LLC · San Antonio, TXN750HPRegistration Pending · Knoxville, TNRegistration pendingN75462Brown Helicopter Inc · Pensacola, FLN767NADh Helicopter Inc · Whitefield, MEN771ARVertical Access Corp · Lewes, DEN775BBCopter Lease LLC Trustee · Albuquerque, NMN806SBScotts Helicopter Service · Le Sueur, MNN82276Air Cav Helicopters LLC · Wilmington, DEN826HFArmy Aviation Hertiage Foundation And Museum · Hampton, GAN839PFRice Aircraft Services Inc · Olivehurst, CAN841MRock Creek Leasing LLC · Sapulpa, OKN849DBD & B Aviation Brokerage Services LLC · Wilmington, DE
Back to AD 2009-15-13