OpenAirDocs.org
AD 2009-13-06 R1

Registered aircraft · 2,130

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-13-06-R1')
    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-13-06-R1')
  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.

N7VRAja Aviation LLC · Hutchinson, MNBuilt 1978 · S/N 31T-7804010N8006JCrimson Star LLC · Virginia Beach, VABuilt 1981 · S/N 27-8154009N800DKBartlett Paul H · Nebo, NCBuilt 1976 · S/N 31-7612110N800LPC A Aviation Corp · Clifton, TXBuilt 1983 · S/N 31-8352009N800MWNorpel Express LLC · New Bedford, MABuilt 1981 · S/N 31-8252011N801CHRisse Greg L · Lincoln, CABuilt 1974 · S/N 31-7405460N801HLKp Equipment Investments LLC · Cottonwood, AZBuilt 1979 · S/N 31T-8020016N802GAMns Asset Management LLC · Dover, DEBuilt 1981 · S/N 31-8152103N8033RGoodson Aviation LLC · Tallahassee, FLS/N 31-7952065N8050YGmm Records · Big Pine Key, FLBuilt 1962 · S/N 27-2098N805MMBlackburn Steven D · Palmetto Bay, FLS/N 31-7812108N805NJFreedom Capital Air LLC · Winchester, TNBuilt 1980 · S/N 31-8052109N8063MFriar Aerospace Group LLC · Jacksonville, FLBuilt 1978 · S/N 31-7852023N806RRIsland Flights Inc · Wilmington, DES/N 27-8054052N8075RTahoe Creations Inc · Zephyr Cove, NVS/N 278054004N807ABSunward Aviation Services LLC · Merritt Island, FLS/N 31-8152183N808ABSunward Aviation Services LLC · Merritt Island, FLS/N 31-8052128N80FFP A M Aviation LLC · Portsmouth, NHBuilt 1972 · S/N 27-7304958N80GVMoro Aircraft Leasing Inc · Two Rivers, AKBuilt 1975 · S/N 31-7552003N80HSN80hs LLC · Wilmington, DES/N 31P-7300164N80LKEti Aviation LLC · Boynton Beach, FLBuilt 1977 · S/N 31-7712103N80MALsc Construction Inc · Perris, CAS/N 31T7720043N8124YMatthews Grover C · Hardinsburg, KYBuilt 1966 · S/N 27-3237N812TBTwin Aviation LLC · Coushatta, LABuilt 1981 · S/N 31-8152113N8131Regional Air & Transport LLC · Mims, FLBuilt 1981 · S/N 31-8152032N81615Heyl Holdings LLC · Orlando, FLBuilt 1953 · S/N 27-2322N817JBBenham James M · College Station, TXS/N 27-4561N818BRMarc Inc · Bolton, MSBuilt 1981 · S/N 318152102N818CCFlyit LLC · Camas, WAS/N 27-2977N818MJPika Design Inc · Spring Hill, KSS/N 27-2486N818SFSierra Foxtrot LLC · Dodge City, KSBuilt 1980 · S/N 31T-8004018N819SWWho Dey LLC · Savannah, GABuilt 1981 · S/N 31T-8104059N81EDNav-Pete LLC · Memphis, TNBuilt 1979 · S/N 31-7952220N81MSCapital Craft LLC · Wilmington, DES/N 31T-8104007N820FSAir Arctic Inc · Fairbanks, AKBuilt 1979 · S/N 317952185N820JHHughes Leasing Co · Miami, FLBuilt 1981 · S/N 318152015N821GMHoosier Aviation LLC · Terre Haute, INBuilt 1957 · S/N 23-1247N8247GCity Of Stuttgart · Stuttgart, ARBuilt 1973 · S/N 27-7305012N824CBHelfrick Edward W Jr · Elysburg, PABuilt 1981 · S/N 31T-8104052N824PGMount Olive Flight Club LLC · Mount Olive, NCBuilt 1982 · S/N 31-8252055N827ECPacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 27-8154005N827LPSagamore Aviation LLC · Lewes, DES/N 31T-7904048N827RDGoyo Air LLC · Miami, FLBuilt 1976 · S/N 31-7652094N828HJPegasus Air Charter LLC · Hartford, CTBuilt 1980 · S/N 31-8052160N828KTJones Larry · Anchorage, AKBuilt 1980 · S/N 318052098N828LUMuldrow Erik · Newport, KYBuilt 1958 · S/N 23-1373N82BLSkylens LLC · Hammond, LAS/N 27-7754049N82PGAugustus Air LLC · Mc Allister, MTBuilt 1981 · S/N 42-8001070N82XLFast Fly Inc · Dallas, TXBuilt 1981 · S/N 31T-8166034N834NQAlaska Door LLC · Wasilla, AKBuilt 1977 · S/N 31-7752070
Back to AD 2009-13-06 R1