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.

N8938FSouthern Cross Aviation Inc · Wilmington, DEBuilt 1964 · S/N 44-0009N8944FFitzgerald Brian B · Gettysburg, PAS/N 15-0021N8948FO Reilly Thomas P · Oscoda, MIBuilt 1965 · S/N 15-0024N8950FAloft · Haiku, HIS/N 15-0026N8962FEmbry Aero Ltd · Greenville, ILBuilt 1973 · S/N 430196N8973FAvelan Enterprises Inc · Elm Grove, LABuilt 1973 · S/N 430195N8990FDeon Esterhuizen Inc · Clearwater, FLBuilt 1974 · S/N 640313N8SLLauff Samuel Jr · Ocala, FLS/N 570713N90270Dunn Larry W · Anderson, SCBuilt 1966 · S/N 66-18283N90271Gartman Jerald B · Morehead City, NCBuilt 1965 · S/N 65-18261N90586Lauff Samuel Jr · Ocala, FLS/N 64-18014N9061RCavender Matt · Howe, TXBuilt 1967 · S/N 47-0696N9061SObrien Derrick P · Lehigh Acres, FLS/N 76-0609N9064SCain James W · Big Rapids, MIS/N 36-0488N907ALTjm Ventures Inc · Rio Verde, AZBuilt 1996 · S/N S1742N911THDagnon Scott R · Driggs, IDBuilt 1969 · S/N 291093N911VCDetgen Ernest J · Carmen, OKBuilt 1965 · S/N 124-0144N916JGGriffin Aerospace Solutions LLC · Bridgeport, WVBuilt 1996 · S/N 0041N9282FBox Helicopters Inc · Cotulla, TXBuilt 1974 · S/N 340289N9286FFlying High Like A Bird In The Sky · Longwood, FLBuilt 1974 · S/N 1040368N9291FHealey David A · Hammondsport, NYBuilt 1975 · S/N 850428N92PCEnright Arne P Trustee · Ward Cove, AKBuilt 1980 · S/N 1290867N931CPTriggs Andrew · Las Vegas, NVS/N S1652N9323FCouch Bill A · Palestine, TXBuilt 1964 · S/N 24-0025N9326FLelys · Orland, CABuilt 1964 · S/N 24-0031N9333FFire Bird Aviation Inc · Vivian, LAFirst renewal noticeBuilt 1964 · S/N 34-0040N9333VFletcher Jeffrey A · Belle Chasse, LABuilt 1963 · S/N 53-0207N9350FSale Reported · Perry, GASale reported, pending cancellationBuilt 1964 · S/N 0045N9361FRmw Services LLC · Mckee, KYBuilt 1964 · S/N 54-0082N9369FSauer David A · Palmetto Bay, FLFirst renewal noticeBuilt 1964 · S/N 44-0070N9374FPierson Robert N · Nora, MNBuilt 1964 · S/N 54-0086N9385FReynolds Darryl G · Wills Point, TXBuilt 1964 · S/N 74-0112N9390FPennington Mitchell T · Medley, WVS/N 74-0114N9423FAvex Holdings Heli Inc · Lewes, DEBuilt 1965 · S/N 65-0207N9428FBargo Aviation Services LLC · Crittenden, KYBuilt 1965 · S/N 0175N9440FPatton Phillip F · Gold Hill, NCBuilt 1965 · S/N 55-0195N9442FRhodes Terry G · Snohomish, WABuilt 1966 · S/N 115-0213N9468FColeman Harold D · Pikeville, KYBuilt 1966 · S/N 106-0264N9485FGonzales David M · Corvallis, ORBuilt 1966 · S/N 1260294N9489FHensley Richard · Bertram, TXS/N 870325N9492FDeer Creek Helicopters LLC · Chico, CABuilt 1973 · S/N 1030245N9504FRons Air Service Inc · Two Buttes, COBuilt 1968 · S/N 870334N9516FKelly David · Issaquah, WABuilt 1967 · S/N 170311N9517FS Martinez Livestock Inc · Moxee, WABuilt 1967 · S/N 170312N95583Reynolds Darryl G · Wills Point, TXS/N 191068N9559FGeco Inc · Wilmington, DEBuilt 1969 · S/N 890443N9561FBarrows Carl A · Lisle, NYBuilt 1970 · S/N 200450N9563FClunie David A · Bangor, PABuilt 1971 · S/N 200447N9569FClassic Helicopter Corp · Auburn, WABuilt 1971 · S/N 310461N958CPJoslyn Larry J · Las Vegas, NVBuilt 1996 · S/N S1710
Back to AD 2011-01-52