AD 2011-01-52
Registered aircraft · 416
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:2011-01-52')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-01-52')
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:2011-01-52') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-01-52') 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.
N340DCItb Sokolowski LLC · Lewes, DEN3417HGc Monitoring Inc · Bellevue, WAN345MHKinzie Industries Inc · Erie, COExpired dealerN34LBVenture Helicopters LLC · West Lafayette, INN355SDBofus Aviation LLC · Helena, MTN361BHDixon Thomas R · Lance Creek, WYN3624TMaxess Inc · Thonotosassa, FLN3625TBlade Runners Chopper LLC · Sunbury, OHN3626BBarney Thomas E · Cresco, PAN366GCHavens Aviation LLC · Blacklick, OHN367RWSpies Robert Charles Sr · Kingman, AZN37750Bacon Gregory · Prairie Home, MON380MCVeturis David L · Lake Forest, CAN385TATomlinson Aviation Inc · Ormond Beach, FLN388HFEchelon Right LLC · Springfield, TNN38ABJerry Lay Aviation LLC · Minonk, ILN3947CHelocraft Holding Co Inc · Pembroke Pines, FLN396CPAir 1 LLC · Newark, DEN3TFHelicopter Accessory Service East · Pensacola, FLN411JCFlying Z Ranch LLC · Douglas, WYN413LHRatcliff Dustin Matthew · Saltville, VAN41THLammers Ross L · Cumming, GAN426GGulf Coast Helicopters Inc · Pearland, TXN4276REchols Mark R · Diana, TXN444EDunker Quinn E · Morse Bluff, NEN451JRFathom Aviation LLC · Burley, WAN451MCAero-Tech Helicopters LLC · Kingstree, SCN47SDWampler William C · Canton, TXN48155Classic Rotors Museum · Ramona, CAN4853STurley Gregory D · Pell City, ALN49WGGarlock Walter G · Oconomowoc, WIN5001FReynolds Darryl G · Wills Point, TXN50045Drive A Tank Inc · Kasota, MNN500HSDaniels Richard L · Bow, WAN5015VFoos LLC · Vancouver, WAN503JNTailwind Investments LLC · Zeeland, MIN503QDSchroth Charles D · Gustavus, AKN504JNPolarblast LLC · Bellefonte, PAN511BHParis Air Inc · Vero Beach, FLN511MKAircraft Guaranty Corp Trustee · Oklahoma City, OKN511RJCarman Scott C · Port Orange, FLN515PHGulf Coast Helicopters Inc · Pearland, TXN5160NFox Judy S · Ridgefield, WAN521RSJj Airlift Inc · Broomfield, CON522TTHarris Kenneth L · Greeley, CON525GHLauff Samuel Jr · Ocala, FLN526LWN526lw LLC · Salem, ORN528WTRegistration Pending · New Smyrna Beach, FLRegistration pendingN531TCJj Aviation LLC · Allentown, PAN536XDel Rio Aviation Inc · Paso Robles, CA
Back to AD 2011-01-52