OpenAirDocs.org
AD 2009-10-09 R2

Registered aircraft · 8,565

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.

N5776GWilliams Timothy · Byron, GABuilt 1969 · S/N 15071276N5777GZawtocki Ronald · Little Falls, NYBuilt 1969 · S/N 15071277N5779GChapman Jeremy R · Niagara Falls, NYBuilt 1969 · S/N 15071279N5780GAlvarez Faust M · Helena, MTBuilt 1969 · S/N 15071280N5781GWilliams Lynwood A · Clayton, NCBuilt 1969 · S/N 15071281N5785GBrown Colin M · Williamstown, NJBuilt 1969 · S/N 15071285N578MAByte Networking LLC · Juneau, AKFirst renewal noticeBuilt 1967 · S/N 15068091N5795GRhodes Tom B · Dallas, TXBuilt 1969 · S/N 15071295N5799GBafa LLC · Lewes, DEBuilt 1969 · S/N 15071299N579MAJones Andrew W · Turner, MTBuilt 1967 · S/N 15068081N5804GSkylands Air LLC · Port Orange, FLBuilt 1969 · S/N 15071304N5808GMoncrieffe Ainsworth L · Aurora, COBuilt 1969 · S/N 15071308N5811GBransky Camber · Griffin, GABuilt 1969 · S/N 15071311N5814GEricson Eric · Saint Charles, ILBuilt 1969 · S/N 15071314N5816GGwyn Devin R · Dallas, ORBuilt 1969 · S/N 15071316N5817GWilliams James B · Bonifay, FLBuilt 1969 · S/N 15071317N5818GCirri Joseph F · Deming, NMBuilt 1969 · S/N 15071318N5819GBuchanan Jason A · Nampa, IDBuilt 1969 · S/N 15071319N5821GMatthews Cheyenne B · Marion, IAS/N 15071321N5822GRada Michael F · Eagan, MNS/N 15071322N5824GNairways LLC · Dix Hills, NYS/N 15071324N5825GAuxano Aviation LLC · Newark, DES/N 15071325N5826GKingdom Art LLC · Cologne, MNS/N 15071326N5827GHutchinson Linda M · Grass Lake, MIBuilt 1969 · S/N 15071327N5828GSmith Joshua B · Kenai, AKS/N 15071328N5828RBismark Public Schools · Bismarck, NDBuilt 1971 · S/N 15072234N5830GDunn Michael J · Ozark, ARBuilt 1969 · S/N 15071330N5832GFitzgibbon Patrick D · Waterloo, WIS/N 15071332N5844GLummus David R · West Point, MSBuilt 1969 · S/N 15071344N5845GBerg William J · Aberdeen, SDS/N 15071345N5848GDerby City Aviation LLC · Vero Beach, FLBuilt 1969 · S/N 15071348N5852GSwigart Davis Holdings Inc · Upland, CABuilt 1969 · S/N 15071352N5853GJohnson Robert K · Monte Rio, CABuilt 1969 · S/N 15071353N5857GWhitver Jeremy W · Ankeny, IABuilt 1969 · S/N 15071357N5860GRegistered aircraftBuilt 1969 · S/N 15071360N5864GScarabin Jim D · Apalachicola, FLBuilt 1969 · S/N 15071364N5867CGunnarsson Jon · Concrete, WABuilt 1970 · S/N 15072277N5867GCrowley Kelly P · Mount Pleasant, SCBuilt 1969 · S/N 15071367N5872GCramer John A · Marana, AZBuilt 1969 · S/N 15071372N5877GClegg Stephen A · Port Orange, FLBuilt 1969 · S/N 15071377N5883GDerry Delmar D · New Market, IABuilt 1969 · S/N 15071383N588BRTraining Planes LLC · Tampa, FLS/N 15281860N5890GPommer Timothy J · Kittanning, PABuilt 1969 · S/N 15071390N5891GWebb Christopher L · Burns, TNBuilt 1969 · S/N 15071391N5896GYtsera Air Fred LLC · Lyndonville, VTBuilt 1969 · S/N 15071396N5898GIsaza Alvaro · Westminster, MDBuilt 1969 · S/N 15071398N58BWarnick Ronald S · Cascade, MTBuilt 1968 · S/N 15068409N58LJL&J Aviation Inc · Atwater, CABuilt 1985 · S/N 15285959N5900JAir America LLC · Sioux Falls, SDS/N A1500200N5903GRybarczyk Mathias M · Rice Lake, WIS/N 15071403
Back to AD 2009-10-09 R2