AD 97-05-06

Registered aircraft · 134

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:97-05-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-05-06')
  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.

N8045SHenry Mark A · Dickinson, TXBuilt 1964 · S/N 85-0365N8047LHolmes Frank L · Enterprise, ALBuilt 1967 · S/N 47-0699N8049PFranklin Ricky L · Glade Hill, VAS/N 56-0535N8049WTennis Gayland L · Bath, MIBuilt 1965 · S/N 75-0349N8135LTri County Rentals And Sales Inc · Bell, FLS/N 580847N8708FCruiser 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-0127N8794FMundell Terry D Trustee · Rosston, OKBuilt 1962 · S/N 103-0002N8799FNew England Equip Corp · Auburn, MARevoked, canceledBuilt 1962 · S/N 0126N8800FWaller 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-0266N8901FBrookside 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 0004N8938FSouthern 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-0026N8SLLauff Samuel Jr · Ocala, FLS/N 570713
Back to AD 97-05-06