OpenAirDocs.org
AD 2009-10-09 R2

Registered aircraft · 8,563

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

N10312Allmann Mark F Trustee · Kent, WABuilt 1973 · S/N 15074837N1031SRedmon James A · Frisco, TXBuilt 1977 · S/N 15279996N1032MHoyer Bryan H · Friday Harbor, WABuilt 1970 · S/N 15071732N1037MHager Winfield D · Peytona, WVBuilt 1970 · S/N 15071737N10380Jones Jeffrey J · Wallingford, PABuilt 1973 · S/N 15074842N103DCCarver Clarence K · Lutz, FLBuilt 1973 · S/N 15075419N103FRSargent William A · Watford City, NDBuilt 1974 · S/N 15075569N103UC426th Aero Squadron LLC · Cropwell, ALBuilt 1980 · S/N 15284243N10403Burgess Michael A · Wagener, SCS/N 15074846N10425Moskewich Raymond J · Morgan, VTS/N 15074854N10428Stoup Kevin D · Altus, OKS/N 15074855N10439Great Lakes Air Ventures LLC · Mason, MIBuilt 1973 · S/N 15074860N10452Demott Steven J · Stanley, WIBuilt 1973 · S/N 15074864N10454Ratliff Byron L · Paragould, ARBuilt 1973 · S/N 15074865N10455Cowden Ryan A · Everson, WABuilt 1973 · S/N 15074866N10459Ender Richard M · Rye, NHBuilt 1973 · S/N 15074868N10466Richards Matthew · Southaven, MSS/N 15074870N10473Vincent Geoffrey M · Andover, KSBuilt 1973 · S/N 15074873N10474Some Beech LLC · Bolivar, MOBuilt 1973 · S/N 15074874N10478Van Winkle Nicolas A · Renton, WABuilt 1973 · S/N 15074877N10483Tennant Michael D · Granite Falls, WAS/N 15074881N10487Wonderboy Aviation LLC · Hollsopple, PABuilt 1973 · S/N 15074885N10488Heller John S Sr · Jackson, WIBuilt 1973 · S/N 15074886N10495Pacific Electro Mechanical Inc · Pearl City, HIBuilt 1973 · S/N 15074888N10498Scoma Steven G · Rhome, TXS/N 15074890N104FDDippolito Michael M · Norristown, PABuilt 1968 · S/N 15068727N104JVPryor Michael C · Riverview, FLBuilt 1967 · S/N 15066392N104KMMorrison Mitchell A · Forest, VABuilt 1970 · S/N 15072415N104SKAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1969 · S/N 15071907N104UCAspiring Aviators Aero Club · Winter Haven, FLS/N 15284673N10505Metro Flyers LLC · Paducah, KYBuilt 1973 · S/N 15074894N10507Pch Aviation LLC · Elmhurst, ILBuilt 1973 · S/N 15074896N10509Mckenna Andrew J Sr · Waynesville, OHBuilt 1973 · S/N 15074897N1050CCourser Ezra D · Columbiaville, MIBuilt 1973 · S/N 15074893N10518Post Ryan · Carmichaels, PAS/N 15074900N10524Putrakul Kobkit · London, KYS/N 15074902N10548Scootair LLC · Alburgh, VTBuilt 1973 · S/N 15074908N10557Parker Helicopter LLC · Watsonville, CABuilt 1973 · S/N 15074909N10565Pribyl Cris M · Hennessey, OKS/N 15074912N10568Buchner Mark L · Springfield, VABuilt 1973 · S/N 15074914N10574Osterberg Douglas L · Neenah, WIBuilt 1973 · S/N 15074916N10577Hatch Arthur S Jr · Mt Vernon, TXBuilt 1973 · S/N 15074917N1058MAir Combat Museum · Springfield, ILBuilt 1969 · S/N 15070998N10592Pedrick William M · Dixon, CABuilt 1973 · S/N 15074919N105ASJohnson Scott R · North Hampton, NHBuilt 1973 · S/N 15074786N105DPPulscher Brian J · Sand Springs, OKBuilt 1968 · S/N 15068960N105ESFrederick Sport Flyers Inc · Washington Grove, MDS/N 15079000N105UCStem Aviation Academy · Carlsbad, CABuilt 1985 · S/N 15285998N10604Bittner Vernon J · New Richmond, WIBuilt 1973 · S/N 15074922N10615Tarr Sheryl L · Spokane Valley, WABuilt 1973 · S/N 15074925
Back to AD 2009-10-09 R2