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.

N300PJLegacy Of Speed LLC · Warsaw, INBuilt 1975 · S/N HC2AN300PM300pm LLC · Bloomington, INBuilt 1978 · S/N 310R1382N300PSRight Coast Ventures LLC · Royse City, TXBuilt 1968 · S/N 17257501N300QRPdq Flight Inc · Garden City, NYBuilt 1979 · S/N 17273539N300REMoreau Leo B · Wasilla, AKBuilt 1965 · S/N 30-841N300RFRivers Robert A · Oxford, NCBuilt 1983 · S/N BJ-2N300RGRein Richard C · St George, UTS/N AA5A-0159N300RJTcj Kqc LLC · Robstown, TXBuilt 1976 · S/N 32R-7680286N300RRRegan Richard Michael · Leesburg, VAS/N CE-177N300RTChoux Aviation LLC · Cypress, CABuilt 1983 · S/N E-2074N300RVHall Farms Inc · Garfield, KSBuilt 2003 · S/N 24740N300RWWilliams Ray L · Chapmansboro, TNS/N 01N300SAWhalen Sean B · Naples, FLS/N CE-545N300SBGustafson Cody A · Corvallis, ORBuilt 1993 · S/N 001N300SKKayrouz Sebastien V · Richardson, TXBuilt 1978 · S/N R18200663N300SQVortex Aviation LLC · Houston, TXBuilt 1979 · S/N 414A0416N300SXSpencer Scott V · Washington, UTBuilt 2006 · S/N 38N300TFSouthern Cross Aviation Inc · Wilmington, DEBuilt 1978 · S/N 1001N300THPacific Flight Academy LLC · Honolulu, HIBuilt 1972 · S/N TH-266N300TLAlls Peyton H · Raleigh, NCBuilt 2003 · S/N 40067N300TTDg Aero LLC · Little Rock, ARBuilt 1980 · S/N CE-906N300UBoard Of Regents Of The Univeristy Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020226N300UHAlba Leasing Services LLC · Scottsdale, AZBuilt 2016 · S/N 13964N300UMMurray Air LLC · Patoka, ILBuilt 1982 · S/N 32R-8213043N300UPNeo Terra Aviation LLC · Setauket, NYBuilt 2005 · S/N 1199N300VCReam Real Estate LLC · York, PAS/N 2106N300VTCarroll James K · Klamath Falls, ORBuilt 1999 · S/N DM0276N300WBarn Miami Inc · Miami, FLBuilt 1995 · S/N 010N300WDPlane Fun Inc Tr Trustee · Snellville, GAS/N 5081N300WEK & S Aero LLC · West Chester, PABuilt 1979 · S/N 32R-7985007N300WFAmoth Kurt J Trustee · White Salmon, WABuilt 1997 · S/N 18280015N300WLRosen Robert D · Lewisville, NCBuilt 1977 · S/N 32R-7780474N300WSOdyssey Aviation LLC · Raleigh, NCBuilt 1992 · S/N 687-92N300WYChupka William J · Riverton, WYBuilt 1965 · S/N 28-21280N300WZNicholas Christopher · Williamsville, NYBuilt 2007 · S/N 11622N300XASale Reported · Henderson, NVSale reportedBuilt 1990 · S/N 021N300XTExtra300 LLC · Anchorage, AKBuilt 1991 · S/N 023N300YBGospel Ministries International Inc · Collegedale, TNBuilt 1986 · S/N 24-3010N30101Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995069N3010ELenzen Richard D Dr · Antioch, ILBuilt 1978 · S/N 28-7916167N3010GJerry Slough Aviation LLC · Bakersfield, CAFirst renewal noticeS/N 18013CN3010KGoodwin David · Edinburg, NYBuilt 1978 · S/N 28-7911086N3010LJones Johnny R · Thermopolis, WYBuilt 1965 · S/N 310J0010N3010TBb Air Corp · Tulsa, OKBuilt 1979 · S/N 32-7940060N3010WSunwest Aviation Inc · Santa Ynez, CABuilt 1995 · S/N 28-43016N3010XHelifun LLC · Austin, TXBuilt 2007 · S/N 11685N3010ZClemente Matthew J · Troy, NYBuilt 1959 · S/N 22-6961N30112Leonard Kevin J · Wagner, SDBuilt 1968 · S/N 17701066N30114International Aviation Group LLC · Lake Wales, FLBuilt 1978 · S/N 28-7916076N30116Registration Pending · Benson, AZRegistration pendingBuilt 1968 · S/N 17701068
Back to AD 2007-04-19 R1