OpenAirDocs.org
AD 2012-10-13

Registered aircraft · 13,306

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

N2056NN2056n LLC · Wilmington, DEBuilt 1978 · S/N TJ-156N2056SAcevedo Adriel · San Antonio, TXBuilt 1975 · S/N 21061023N2058CScorpion Aviation LLC · Hemet, CABuilt 1978 · S/N TK-85N2059PNiemi Aviation LLC · Glyndon, MNBuilt 1998 · S/N TJ-159N205ASTurnbull Moak & Pendergrass LLC · Birmingham, ALBuilt 2023 · S/N 9344N205BFWells David L · Neosho, MOBuilt 2005 · S/N 29-0386N205BZEmbedded Advantage LLC · Chelsea, MIBuilt 2005 · S/N 29-0411N205CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0207N205CDNuclear Speed Inc · Emerald Hills, CABuilt 2023 · S/N 9145N205KTMha Interests LLC · Spring, TXBuilt 1981 · S/N TH-1286N205SC5sc LLC · Bismarck, NDBuilt 2025 · S/N 10630N205WHJp Real Estate Management Inc · Van Nuys, CABuilt 2020 · S/N 2051N20602Bromschwig Kurt F Trustee · Montgomery, TXS/N TJ-173N2061KMile High Air Inc · Canyon, TXBuilt 1978 · S/N TJ-161N2063JWest Aviation Inc · Creston, IABuilt 1978 · S/N T18803353TN2066JKlein Flying Service Inc · Lawrenceville, ILBuilt 1978 · S/N T18803356TN2069KFiloteo James · Woodinville, WABuilt 1978 · S/N TK-74N2069YBeach Helicopter Services LLC · Chesapeake, VABuilt 1979 · S/N TK-76N206BSBlue Star Gas Fleet Services Co · Central Point, ORBuilt 1968 · S/N P206-0434N206CTDe Creeft Joseph M · Homer, AKBuilt 1981 · S/N U206-06090N206DMBushwood Air LLC · Coeur D Alene, IDBuilt 1976 · S/N U20603512N206EKKoch & Koch Inc · Grass Valley, CABuilt 1981 · S/N U20606291N206GSmith Air LLC · Cascade, IDBuilt 1979 · S/N U20605268N206GAPrijatel Thomas J · Cordova, AKBuilt 1979 · S/N U20605288N206GVSawtooth Flying Service · Mccall, IDBuilt 1978 · S/N U20604833N206HHSawtooth Flying Service Inc · Mccall, IDBuilt 1980 · S/N U20605675N206JWMarley William Jay Jr · Homer, AKBuilt 1981 · S/N U20606283N206KDStubblefield Fancho F Jr Trustee · Amity, ORBuilt 1979 · S/N U20604981N206RCPaloma Aviation LLC · Fruitland, IDBuilt 1974 · S/N U20602431N206SMAugusta Aviation LLC · Madison, MSBuilt 2011 · S/N 0171N206SNDye Seed Ranch Inc · Spokane Valley, WABuilt 1979 · S/N U20605101N206TZTeton Leasing LLC · Polatello, IDBuilt 1979 · S/N U20605165N206WDCritical 32 Degrees LLC · Milton Freewater, ORBuilt 1984 · S/N U20606832N206WPMorrison Richard Lee Trustee · Anchorage, AKBuilt 1980 · S/N U20605897N206XKennedy Benjamin · Boulder, COBuilt 1968 · S/N P206-0479N206XPAirborne Flyer LLC · Ashland, NHBuilt 1983 · S/N U20606701N2070SThompson Robert V Trustee · Crawford, COBuilt 1975 · S/N 21061037N2071YRossiter Brahm J · Lemoore, CABuilt 1997 · S/N E-3120N2073LBravo Wings II LLC · Grants, NMBuilt 1976 · S/N TJ-73N2075JL & L Flying Inc · Glen Allan, MSBuilt 1978 · S/N T18803365TN2076SWarden Air LLC · Warden, WABuilt 1975 · S/N 21061043N207AEAe Leasing LLC · Biddeford, MEBuilt 2024 · S/N 9820N207DFDouble R Air LLC · Miami, FLBuilt 1978 · S/N 20700430N207DGRwr Air Inc · Tok, AKBuilt 1969 · S/N 207-00070N207DVWiseman Charles N · Midland, MIBuilt 2002 · S/N 0183N207GAngry Dragon LLC · St Thomas, VIBuilt 1969 · S/N 20700091N207WMG A Associates LLC · Port Orange, FLBuilt 2008 · S/N 3360N207WTHenson Alan · Houston, TXBuilt 2000 · S/N E-3308N2080JWoelfel Tim A · Madisonville, TXBuilt 1978 · S/N T18803370TN2082JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N T18803372T
Back to AD 2012-10-13