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.
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
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.
N8045SHenry Mark A · Dickinson, TXN8047LHolmes Frank L · Enterprise, ALN8049PFranklin Ricky L · Glade Hill, VAN8049WTennis Gayland L · Bath, MIN8135LTri County Rentals And Sales Inc · Bell, FLN8708FCruiser LLC · Munger, MIN8714FDown East Emergency Medicine Institute · Orono, MEN8719FKinzie Wayne · Alva, OKN8724FDel Rio Aviation Inc · Paso Robles, CAN8733FLay Jerry K · Minonk, ILN8743FPrice Keyth E · Ossian, INN8746FLarsen Jeffrey A · Casa Grande, AZN8749FTsr Sky Chicken LLC · Cleveland, TXN8751FLay Jerry K · Minonk, ILN87592Sorensen Eric N · Hilo, HIN8768FReynolds Darryl G · Wills Point, TXN8773FSera/Southeast Regional Aviation Inc · Bowdon, GAN8774FReynolds Darryl G · Wills Point, TXN8781FClements Kenneth B · Laguna Niguel, CAN8782FDinger Kevin L · Naples, FLN8786FPrice Keyth E · Ossian, INN8794FMundell Terry D Trustee · Rosston, OKN8799FNew England Equip Corp · Auburn, MARevoked, canceledN8800FWaller County Aviation Museum · Waller, TXN8802FMc Lane Jonathan T · Morrisville, NCRevoked, canceledN8803FAg Helicopters Inc · Ft Collins, CORegistration revokedN8821FRuhlman Dan C · Youngsville, PAN8823FHudson Valley Helicopters Inc · Wilmington, DEFirst renewal noticeN8828FJohnson Martin L · Agua Dulce, CAN8835FUniversal Exports LLC · Schuylkill Haven, PAN8836FWooding William W · Anacortes, WAN8840FPinchorski Ronald G · Wiconisco, PAN8845FDowning Darrell W · Drakesville, IAN8856FRotorcraft Unlimited LLC · Brooksville, FLN8863FCain James W · Big Rapids, MIN8866FReynolds Darryl G · Wills Point, TXN8871FGarvey Michael · Leesville, SCN8872FCameron William Douglas Jr · Lexington, VAN8887FNiec Steven M · Clio, MIN8891FDetgen Jim · Traverse City, MIN8901FBrookside Aero LLC · Grants Pass, ORN8911FA And J Aviation Services LLC · Titusville, FLN8913FLay Jerry K · Minonk, ILN8925FAztec Aviation · Geneseo, ILN8928FDenver Aerospace Science Museum · Watkins, CON8938FSouthern Cross Aviation Inc · Wilmington, DEN8944FFitzgerald Brian B · Gettysburg, PAN8948FO Reilly Thomas P · Oscoda, MIN8950FAloft · Haiku, HIN8SLLauff Samuel Jr · Ocala, FL
Back to AD 97-05-06