AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-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:2007-04-19-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.

N3308SSutton Aircraft Salvage LLC · Palmer, AKBuilt 1973 · S/N 18502267N3308ZWeber Daniel Troy · Port Charlotte, FLS/N 22-7239N33092Shepherd Edward H · Grass Valley, CABuilt 1975 · S/N 28-7525153N33095Kollmansberger James K · Fond Du Lac, WIBuilt 1975 · S/N 28R-7535120N33096United States Air Force Owner · Offutt Afb, NEBuilt 1975 · S/N 28R-7535121N3309CScott Parker H · Bulverde, TXBuilt 1978 · S/N R18200270N3309JMomentum Foundation · Tullahoma, TNS/N 15066009N3309SCessna 210 N3309s LLC · Yellville, ARBuilt 1969 · S/N 21059109N3309XCabanas Alexis Santiago · Stroudsburg, PAS/N 310L-0159N3309YRuschak Donald A · Charleroi, PABuilt 1962 · S/N 18254309N3309ZRubbert Randy C · Reynolds, NDBuilt 1959 · S/N 22-7241N330ARegistered aircraftBuilt 1954 · S/N 22-1939N330ALDemuri Daniel J · Woods Cross, UTBuilt 1990 · S/N 3030N330BDD & J Holdings LLC · Ellis, IDBuilt 1973 · S/N 18261634N330CAOsborn Richard H · Bakersfield, CABuilt 1965 · S/N TC-904N330CDDec Enterprises LLC · Naples, FLBuilt 2005 · S/N 1319N330CLCoalos Inc · State College, PANon-citizen corporation, flight hours not reportedS/N CD-488N330CPCharlie Pop Flyers Inc · Jacksonville, FLBuilt 1969 · S/N 30-1884N330CTRobinson Paul J · Saint Joseph, MOBuilt 1974 · S/N 17702158N330DDUtah State University · Logan, UTBuilt 2002 · S/N 3401N330DGAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1991 · S/N 766N330DJPrecision Aviation Specialty Services LLC · Bay Minette, ALBuilt 1992 · S/N CE-1707N330DPAdvanced Commercial Group LLC · Helena, MTBuilt 2005 · S/N 1417N330FSkydive Wayland LLC · Melbourne, FLBuilt 1957 · S/N 34329N330FTSuwannee Arrow LLC · Clearwater, FLBuilt 1982 · S/N 28-8216209N330GBBrenner Gary L · Mission Viejo, CABuilt 1975 · S/N 18264242N330HLSwift David A Trustee · Springfield, MOS/N 24941N330HPBigman Elliot S · Todd, NCS/N 01N330JDGreen Erik M · Mastic Beach, NYBuilt 1998 · S/N 18280267N330JGCultra LLC · Naples, FLS/N 24-3042N330KGBeats Driving LLC · Falling Waters, WVBuilt 2007 · S/N 40050N330KRCherry Hill Aviation Inc · Freetown, INBuilt 1956 · S/N 22-4152N330LSDawson Douglas · Fernley, NVBuilt 2000 · S/N 001N330MEUnique Educational Experiences · Signal Hill, CABuilt 2000 · S/N 172S8462N330MFWroblewski Peter Ross · Lompoc, CABuilt 2003 · S/N 0033N330MMHobbs Phillip E · Saint Augustine, FLBuilt 1983 · S/N 444N330MRJett Aviation LLC · Clovis, NMBuilt 1979 · S/N 340A0721N330MSCanyon Airmotive LLC · Frisco, TXBuilt 1995 · S/N 750-95N330PCaldaso Inc · Peachtree City, GABuilt 1978 · S/N 32-7840164N330PMPractical Education LLC · New York, NYBuilt 2008 · S/N 172S10809N330RLBlue Mountain Flyers · Palmerton, PABuilt 2002 · S/N 2210N330RSSimeone Richard A · Rock Hill, SCBuilt 2021 · S/N 01N330SMSa Aerosports LLC · Kalispell, MTBuilt 2004 · S/N 005N330SXDb Aero Inc · Wilmington, DEBuilt 1995 · S/N JONAS-0007N330TAAdvanced Aerobatics LLC · Ocala, FLBuilt 2002 · S/N 003N330TFMartin Earl · Seneca Falls, NYBuilt 1996 · S/N 3246032N330WH2k Partners LLC · Dallas, TXBuilt 1989 · S/N CE-1322N330ZVinciguerra Wayne D · Sutter Creek, CABuilt 1960 · S/N CD-227N33107Florida Coastal Flying Club LLC · Titusville, FLBuilt 1975 · S/N 28-7525154N3310DGrewe Mike · Lake In The Hills, ILBuilt 1972 · S/N 310Q-0630
Back to AD 2007-04-19 R1