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.
N839HBlair Helicopter Service Inc · Lemoore, CAN83PHValiair Limited Co Trustee · Casper, WYN8644FBemer Aviation Inc · Glastonbury, CTN8664FBarney Brooke G · Cresco, PAN8665FJack Raven · Elk Mound, WIN868LHJones Aircraft Co LLC · Cross Plains, TNN8700FHouston Police Department · Houston, TXN8708FCruiser 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, INN87898Scott Shawn · Darrington, WAN8794FMundell Terry D Trustee · Rosston, OKN8799FNew England Equip Corp · Auburn, MARevoked, canceledN88007Zanuzoski Alan · Hillsboro, ORN8800FWaller 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, MIN88QQJprg Aviation Inc · Orlando, FLN8901FBrookside Aero LLC · Grants Pass, ORN8911FA And J Aviation Services LLC · Titusville, FLN8913FLay Jerry K · Minonk, ILN8925FAztec Aviation · Geneseo, ILN8928FDenver Aerospace Science Museum · Watkins, CO
Back to AD 2011-01-52