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.

N458KGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1995 · S/N 28-43022N458LBBeedy Lyle G · Derby, KSBuilt 2011 · S/N 20695N458LTN87bb LLC · Monroe, NCBuilt 2024 · S/N 14803N458ME1st Avenue Ttc LLC · Los Angeles, CABuilt 1986 · S/N 739N458RHHamil Robert D · Houston, TXBuilt 2005 · S/N 1688N458RVRussell Steven J · Wilmington, ILBuilt 2006 · S/N 71458N458SCAb Prop Plane I LLC · Metairie, LABuilt 2019 · S/N 4496490N458SGCedar Ridge Aviation LLC · Knox City, TXBuilt 2004 · S/N 10458N458SKKroenke Seth M · Palmer, AKBuilt 2025 · S/N SS-001N458SPChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8323N458SRDr2 Aviation LLC · Valdosta, GABuilt 1972 · S/N 18261409N458SSSos Ranch LLC · Humble, TXBuilt 1975 · S/N TH-569N458TCyclone Services LLC · Fife, WABuilt 1961 · S/N CD-353N458TWFirst Aviation Co · Prospect Heights, ILBuilt 2003 · S/N 0697N458UZStoik David E · Prunedale, CABuilt 1992 · S/N S-10-1-88010N458WTls Aviation LLC · Smyrna, TNS/N 28-24511N458WCSee Forever Holdings LLC · Wilmington, DEBuilt 2010 · S/N 18282235N4590AEllis Darry Lynn · Wasilla, AKBuilt 1956 · S/N 18-4899N4590FDavid Badaczewski · Gettysburg, PABuilt 1976 · S/N 28-7715052N4590JEpic Aviation Inc · New Smyma Beach, FLBuilt 1968 · S/N 28R-30463N4590ROzar Abdurrahman · Virginia Beach, VABuilt 1965 · S/N 28-21336N4590SConner Chad E · Paris, TNBuilt 1975 · S/N TH-676N4590TOdonald John C · Greenville, MIBuilt 1972 · S/N 28R-7235102N4590WBfi Financial Alliances Limited LLC · Cave Creek, AZBuilt 1977 · S/N 13180N4591HCampbell James R · Bennett, COBuilt 1979 · S/N 24-0855N4591KDesmon David L · Everett, WABuilt 1948 · S/N NAV-4-1591N4591RJohnson Robert B · Wichita, KSBuilt 1965 · S/N 28-21337N4591TCherokee 235 LLC · Sidney, NEFirst renewal noticeBuilt 1972 · S/N 28-7210015N4591WRojas Franklyn N · Ocala, FLBuilt 1976 · S/N 13081N4591XCoral Air LLC · Rock Rapids, IAS/N 28-7610045N4592SMays Robert · Centerville, TNBuilt 1976 · S/N TJ-87N4593ABvm LLC · Stonington, CTBuilt 1956 · S/N 18-4903N4593BSale Reported · Anchorage, AKSale reportedBuilt 1955 · S/N 31492N4593FSterling Flight Training LLC · Jacksonville, FLBuilt 1976 · S/N 28-7715054N4593VFranklin Eric J · Anchorage, AKBuilt 1980 · S/N 172RG0330N4593XClubs 2 LLC · Calabasas, CABuilt 1975 · S/N 28-7690046N4593YSoaring Society Of Boulder · Boulder, COBuilt 1967 · S/N 25-4278N4594CSt Johns Aviation LLC · Saint Johns, MIBuilt 1979 · S/N 21063569N4594ELingo Joshua B · Lake Village, ARBuilt 1979 · S/N 18503805N4594F181 Corporation · Charlotte, NCBuilt 1976 · S/N 28-7790048N4594REkblad Carl Allyn · New Port Richey, FLBuilt 1966 · S/N 28-21341N4594XAdventure Ventures LLC · Salem, CTBuilt 1975 · S/N 28R-7635088N4595BBartusek Donald L Trustee · Columbia, MDBuilt 1955 · S/N 31494N4595FSchroeder Herbert D · Plano, TXBuilt 1976 · S/N 28-7790049N4595JPetesch Andrew L · Meriden, KSBuilt 1968 · S/N 28R-30471N4595SHurst Sheldon G IV · Smyrna, GABuilt 1975 · S/N D-9812N4596BLow & Slow LLC · Columbus, OHBuilt 1955 · S/N 31495N4596FJaysix LLC · Greeley, COBuilt 1966 · S/N 185-1150N4596SWaters Mark N · Clovis, NMS/N CE-685N4596URustair Inc · Anchorage, AKBuilt 1979 · S/N U20604990
Back to AD 2007-04-19 R1