AD 2005-10-13
Registered aircraft · 1,224
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:2005-10-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:2005-10-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:2005-10-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:2005-10-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.
N369TAHva Inc · Summersville, WVN369TRChehalem Helicopters LLC · Newberg, ORN369WYReece Construction Company · Marysville, WAN369ZMRegistered aircraftN36KRDragonfly Aviation LLC · Mirando City, TXN36MQRotor LLC · Dover, DEN371AHSlykerman John A · Bakersfield, CAN372NSEwing Flying Service LLC · New Roads, LAN376BTAppshle Air LLC · Long Beach, CAN37WABoston Executive Helicopters LLC · Norwood, MAN382CAChem-Air LLC · Shreveport, LAN382SPTag Aviation LLC · Casper, WYN383FJ&J Holdings And Investments LLC · Phoenix, AZN386PZFast Boy Equipment LLC · Houston, TXN3897UCounty Of Cape May · Cape May Ch, NJN38HHChemair Helicopters Inc · Jefferson, WIN38VABrown Helicopter Inc · Pensacola, FLN39049Aspen Helicopters Inc · Oxnard, CAN390LHDsl Aviation LLC · Perham, MNN39101Scotts Helicopter Service Inc · Le Sueur, MNN3917GBank Of Utah Trustee · Salt Lake City, UTN393SSouthwest Heliservices LLC · Mesa, AZN398WCBucks Air Charters Inc · Wilmington, DEN39MKXtreme Aviation LLC · Falkville, ALN3DW T Waggoner Estates · Vernon, TXN3DUCrile Consolidated Industries Inc · Washington, PAN3TVMission Air Capital Services L L C · San Antonio, TXN3YJHelicopters Inc · Linden, NJN400HEWallace Robert W · Plymouth, MAN400MBPrecision Heli-Support LLC · Mesa, AZN4010GScotts Helicopter Services Inc · Le Sueur, MNN40125N525gm LLC · Bozeman, MTN40290Haddock Flying Service Inc · Salters, SCN402BWLiesch Robert H · Port Orange, FLN4032YBank Of Utah Trustee · Salt Lake City, UTN4037LSouthern Aircraft Consultancy Inc Trustee · Casper, WYN403AHMclaughlin Charles W Trustee · Oxnard, CAN4042GKlein Flying Service Inc · Lawrenceville, ILN405ATRotor Blade LLC · Georgetown, SCN4068GGulf Coast Helicopters Inc · Pearland, TXN406CSSiderius Construction Llp · Kalispell, MTN406DBRight Brother Aviation LLC · Chaffee, NYN407ADOcean Air Helicopters Inc · Port Orford, ORN407CCCounty Of Contra Costa · Martinez, CAFirst renewal noticeN407CHClassic Medical Inc · North Salt Lake, UTN407FCIntermountain Medical Transport LLC · Salt Lake City, UTN407GHRotorcraft Support Inc · Fillmore, CAN407KBOrange County Sheriffs Office · Orlando, FLN407PRWindsock Managmement LLC · Little Rock, ARN407RVHelicopter Services Of Illinois LLC · Fisher, IL
Back to AD 2005-10-13