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.

N839HBlair Helicopter Service Inc · Lemoore, CABuilt 1975 · S/N 1090839N83PHValiair Limited Co Trustee · Casper, WYBuilt 2002 · S/N S1834N8644FBemer Aviation Inc · Glastonbury, CTBuilt 1977 · S/N 770619N8664FBarney Brooke G · Cresco, PABuilt 1977 · S/N 1170641N8665FJack Raven · Elk Mound, WIBuilt 1977 · S/N 1070642N868LHJones Aircraft Co LLC · Cross Plains, TNBuilt 2007 · S/N S1903N8700FHouston Police Department · Houston, TXBuilt 2008 · S/N S1924N8708FCruiser LLC · Munger, MIBuilt 1961 · S/N 111-0020N8714FDown East Emergency Medicine Institute · Orono, MES/N 111-0027N8719FKinzie Wayne · Alva, OKBuilt 1961 · S/N 121-0032N8724FDel Rio Aviation Inc · Paso Robles, CAS/N 12-0039N8733FLay Jerry K · Minonk, ILS/N 22-0052N8743FPrice Keyth E · Ossian, INBuilt 1962 · S/N 42-0063N8746FLarsen Jeffrey A · Casa Grande, AZBuilt 1962 · S/N 42-0067N8749FTsr Sky Chicken LLC · Cleveland, TXBuilt 1952 · S/N 52-0074N8751FLay Jerry K · Minonk, ILBuilt 1962 · S/N 52-0073N87592Sorensen Eric N · Hilo, HIS/N 160432N8768FReynolds Darryl G · Wills Point, TXBuilt 1962 · S/N 62-0092N8773FSera/Southeast Regional Aviation Inc · Bowdon, GAS/N 0097N8774FReynolds Darryl G · Wills Point, TXBuilt 1962 · S/N 0098N8781FClements Kenneth B · Laguna Niguel, CAS/N 62-0105N8782FDinger Kevin L · Naples, FLBuilt 1962 · S/N 0107N8786FPrice Keyth E · Ossian, INS/N 82-0127N87898Scott Shawn · Darrington, WAS/N 440301N8794FMundell Terry D Trustee · Rosston, OKBuilt 1962 · S/N 103-0002N8799FNew England Equip Corp · Auburn, MARevoked, canceledBuilt 1962 · S/N 0126N88007Zanuzoski Alan · Hillsboro, ORS/N S1546N8800FWaller County Aviation Museum · Waller, TXS/N 720111N8802FMc Lane Jonathan T · Morrisville, NCRevoked, canceledBuilt 1962 · S/N 0133N8803FAg Helicopters Inc · Ft Collins, CORegistration revokedBuilt 1962 · S/N 0134N8821FRuhlman Dan C · Youngsville, PABuilt 1963 · S/N 0171N8823FHudson Valley Helicopters Inc · Wilmington, DEFirst renewal noticeS/N 0167N8828FJohnson Martin L · Agua Dulce, CABuilt 1963 · S/N 0173N8835FUniversal Exports LLC · Schuylkill Haven, PABuilt 1963 · S/N 0198N8836FWooding William W · Anacortes, WABuilt 1963 · S/N 43-0196N8840FPinchorski Ronald G · Wiconisco, PABuilt 1963 · S/N 33-0185N8845FDowning Darrell W · Drakesville, IABuilt 1963 · S/N 53-0208N8856FRotorcraft Unlimited LLC · Brooksville, FLS/N 43-0194N8863FCain James W · Big Rapids, MIS/N 63-0243N8866FReynolds Darryl G · Wills Point, TXBuilt 1969 · S/N 0242N8871FGarvey Michael · Leesville, SCBuilt 1963 · S/N 0235N8872FCameron William Douglas Jr · Lexington, VAS/N 63-0238N8887FNiec Steven M · Clio, MIBuilt 1963 · S/N 73-0263N8891FDetgen Jim · Traverse City, MIS/N 83-0266N88QQJprg Aviation Inc · Orlando, FLS/N 0168N8901FBrookside Aero LLC · Grants Pass, ORS/N 0278N8911FA And J Aviation Services LLC · Titusville, FLS/N 0230N8913FLay Jerry K · Minonk, ILBuilt 1963 · S/N 93-0287N8925FAztec Aviation · Geneseo, ILBuilt 1964 · S/N 0307N8928FDenver Aerospace Science Museum · Watkins, COBuilt 1964 · S/N 0004
Back to AD 2011-01-52