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.

N5038RKnecht Ken L · Eagle River, AKBuilt 1976 · S/N 18502985N5038SRegistration Pending · Fort Worth, TXRegistration pendingS/N 28R-35806N5038TBennett Howard N · Georgetown, KYBuilt 1972 · S/N 28-7225326N5038UButler Industries Inc · Amarillo, TXBuilt 1979 · S/N 484-79N5038WMarx Karl E · Juneau, AKBuilt 1961 · S/N 28-40N5038YAileron Buzz LLC · Daytona Beach, FLBuilt 1962 · S/N 27-2044N50395Registered aircraftBuilt 1979 · S/N 493-79N50397Wright Preston T · Deeth, NVBuilt 1979 · S/N 1108-79N5039DUp Above Ak LLC · Wasilla, AKBuilt 1958 · S/N 51139N5039GPhronesis LLC · Tucson, AZBuilt 1979 · S/N 490-79N5039HBig Mountain Aviation Inc · Whitefish, MTBuilt 1975 · S/N 17265311N5039LGreyhawk Aviation LLC · Erie, COBuilt 1979 · S/N 1107-79N5039NGutman Bradley J · Titusville, FLBuilt 1979 · S/N 492-79N5039RSmooth Landings Inc · Cary, ILBuilt 1974 · S/N 17263280N5039TMitchell Robert D · Freehold, NYBuilt 1972 · S/N 28-7225328N503AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2020 · S/N 28020003N503AMAlpha Aviation LLC · Spartanburg, SCBuilt 1982 · S/N 17275767N503ATRegistered aircraftBuilt 1975 · S/N 21060924N503BNAllegrezza Fred · Line Lexington, PABuilt 2005 · S/N 1276N503CAThompson Paul W Jr · Yachats, ORBuilt 1974 · S/N 17263757N503CDLagade Marco C · Lake Mary, FLBuilt 2004 · S/N 0909N503CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283100N503DMLau Wolfgang · Cap Canaveral, FLBuilt 1974 · S/N 150-74N503DS503 Delta Sierra LLC · Silsbee, TXBuilt 2015 · S/N 1099N503ETCarnahan Eric Q · Sardinia, OHBuilt 1965 · S/N 28-10598N503GLWomack Thomas G · Lonoke, ARS/N 0503N503HVHelivision LLC · Concord, NCBuilt 2009 · S/N 12632N503JSAlmont Orchards Inc · Chico, CABuilt 2017 · S/N 18283009N503LWWechter William P · Ravenel, SCBuilt 2008 · S/N 357N503MAHobart Aviation Inc · Akron, OHBuilt 1975 · S/N 17266089N503MDChristy John R · Anchorage, AKBuilt 1963 · S/N 206-0076N503MZWight Schuyler III · Goldsmith, TXBuilt 1998 · S/N 1405N503PVMichaels Scott R · Saint Augustine, FLBuilt 2004 · S/N 3FX014N503RAAirplanes And Coffee LLC · Kalispell, MTBuilt 2001 · S/N 40024N503RFNovember Tango LLC · Richmond, VABuilt 2005 · S/N 40.493N503RTPew Don E · Queen Creek, AZBuilt 1959 · S/N 769N503SBLeemon Ronald D · Prairie Du Sac, WIBuilt 2016 · S/N 5053N503SPNew Horizon Aviation Inc · Warwick, RIBuilt 1998 · S/N 172S8040N503STN503st LLC · Royal Oak, MIBuilt 1959 · S/N 50583N503UAlba Leasing Services LLC · Scottsdale, AZBuilt 2019 · S/N 103/USN503WAThree Rivers Aero Inc · Three Rivers, MIBuilt 1975 · S/N 17265025N5040KRobinson Michael David · Folkston, GAS/N NAV-4-1695N5040MHulme Aviation LLC · Gilbert, AZBuilt 1978 · S/N MB-895N5040POld Seale Properties LLC · Ft Mitchell, ALBuilt 2001 · S/N 2843447N5040RShirley Craig T · Ennis, MTBuilt 1974 · S/N 17263281N5040TGamblin Ryan · Perry, GABuilt 1972 · S/N 28-7205241N5040UAir Data Solutions LLC · Natchitoches, LABuilt 1963 · S/N 206-0040N50412Ride The Kite LLC · Le Claire, IABuilt 1979 · S/N 598-80N5041D5041 Delta LLC · Three Forks, MTBuilt 1958 · S/N 51141N5041HSimplifly LLC · Mesa, AZBuilt 1975 · S/N 17265313
Back to AD 2007-04-19 R1