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.

N5138710fss - Usafa Aero Club · Usafa, COBuilt 2001 · S/N 172S9013N51388Flight Line Resources Inc · Chandler, AZBuilt 2001 · S/N 172S9014N5138DUrlaub James E II · Phoenix, AZS/N 51238N5138ESanders Flight Training Center Inc · Jasper, ALBuilt 1978 · S/N 17271731N5138LFlying Gators Inc · Overland Park, KSBuilt 1967 · S/N 28-4422N5138RBell Ornithopters Flying Club Inc · Eastlake, COBuilt 1974 · S/N 17263355N5138SBarr Jerry L Jr · Mount Pleasant, TXBuilt 1971 · S/N 28-7125532N5138VAdvanced Charter & Instruction LLC · Costa Mesa, CABuilt 2001 · S/N 172S9012N51390Mustang Sally Aviation LLC · Camden, SCS/N 172S10892N51395Rush David A · El Dorado, KSBuilt 1974 · S/N 17264237N5139DEdwards A Clay · Weaverville, CABuilt 1958 · S/N 51239N5139EAero Techniques LLC · Binghamton, NYBuilt 1978 · S/N 17271732N5139LBrown Robert F · Sugarloaf Key, FLBuilt 1968 · S/N 28-4423N5139QNykerk Kory · San Miguel, CABuilt 1972 · S/N 21059639N5139UCoosa Valley Aviation Inc · Wilmington, DEBuilt 2001 · S/N 172S9016N5139XGlatthaar Richard J · Burbank, WABuilt 1969 · S/N 183N5139YB & B Equipment Inc · Cantwell, AKS/N 18-8038N513AFVee Two Inc · Merritt Island, FLBuilt 2021 · S/N 28020044N513AGPlane Fun Inc Tr Trustee · Snellville, GABuilt 2014 · S/N 0050V3N513BLWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 2881855N513CTCoast Flight Training And Management Inc · San Diego, CABuilt 2009 · S/N 172S10925N513CWMurphy Ronald C Jr · Cocoa Beach, FLBuilt 1978 · S/N 32R-7885170N513DWright Aero Inc · Saint Cloud, MNBuilt 1976 · S/N 340A0048N513DNNowakowski Donald K Trustee · Gilbert, SCBuilt 2001 · S/N 24294N513DRSternhagen Richard · Sweetwater, TNBuilt 2005 · S/N 29-0407N513EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13047N513JCMathis Joshua D · Mitchell, INS/N 01513N513JSFox John R · Lansing, KSBuilt 1993 · S/N 513N513KXHart Aviation Enterprises LLC · Jonesboro, ARBuilt 2012 · S/N TH-2342N513LAN318he LLC · Bulverde, TXBuilt 2015 · S/N 13789N513LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2007 · S/N 172S10494N513MSteuber Edward P · Erwin, TNBuilt 1969 · S/N 388N513MCWilliams Val · Victor, IDBuilt 2006 · S/N 18281811N513MMGlacier Peak Aviation LLC · Carnation, WABuilt 2019 · S/N CC18-0094N513MSPark Brian Byung · Anaheim, CABuilt 1992 · S/N 2841347N513NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10764N513PCBaklanov Sergey I · Whitestown, INS/N 1546N513PTLake Timothy Michael · Murfreesboro, TNBuilt 1966 · S/N CD-1053N513PUBrosemer Kathleen M · Sault Sainte Marie, MIBuilt 1983 · S/N 28-8316098N513RCraddock Roger D · Memphis, TNBuilt 1961 · S/N D-6782N513RJGurski Robert C · Lees Summit, MOBuilt 1997 · S/N 23922N513RMRosen Larry M Trustee · Santa Barbara, CABuilt 1977 · S/N AA5B0458N513SCInstant Whip Foods Inc · Columbus, OHBuilt 1978 · S/N 18266293N513SPPlane Old Inc · New York, NYBuilt 2000 · S/N 172S8373N513TDWeber Sandra L · Simpsonville, SCBuilt 1997 · S/N 18280030N513TLN468ha Inc · Middletown, DEBuilt 2008 · S/N 12391N513TRGonzalez Miguel A · Pembroke Pines, FLBuilt 2017 · S/N 3333N513WFMeow Meow LLC · Seattle, WABuilt 2004 · S/N 172S9756N513ZPlain Nuts LLC · Dover, DEBuilt 2005 · S/N 1734N513ZMBullard Aerospace Corp · Boston, MABuilt 1999 · S/N 29-0202
Back to AD 2007-04-19 R1