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.

N38735Schulz Lewis E III · Sand Springs, OKBuilt 1977 · S/N 28-7790581N3873BNpa Baron LLC · Gladewater, TXBuilt 1981 · S/N TH-1255N3873GKronfuss Edward P · Bozeman, MTBuilt 1967 · S/N U206-0873N3873QSkywalker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17259973N3873TDerby City Aviation LLC · Vero Beach, FLBuilt 1967 · S/N 28R-30197N3873WBrault David M · Lake Stevens, WABuilt 1966 · S/N 32-819N3873ZSchok Richard N Jr · Fairbanks, AKBuilt 1961 · S/N 18-7661N38749Epperson Matthew · Moraga, CABuilt 1977 · S/N 32R-7780467N3874GMcfarlane Bradley J · Port Alsworth, AKS/N U206-0874N3874PPearson Joshua J · Unionville, MOS/N 22-3567N3874TSmith Albert G Jr · Lake Jackson, TXBuilt 1967 · S/N 28R-30199N3874WSplit Oak Contracting Inc · Williamson, GABuilt 1966 · S/N 32-820N3874XTr Flying Service LLC · Milan, MNBuilt 1967 · S/N 173N3874YDavenport Henry B III · Charles Town, WVBuilt 1981 · S/N TH-1256N3874ZSlinkard Justin W · Bakersfield, CABuilt 1961 · S/N 18-7734N38752Leblanc Richard · Mclean, VABuilt 1977 · S/N 32R-7780468N3875DJames D Wirt · Goldsby, OKBuilt 1957 · S/N 34575N3875PLonnevik Dennis F · Bigfork, MTBuilt 1955 · S/N 18-4701N3875QAerial Scouting Solutions LLC · Sioux Center, IABuilt 1971 · S/N 17259975N3875TMichael Jin · Renton, WABuilt 1967 · S/N 28R-30200N3875XTate Maurice J · Hope Valley, RIS/N 174N38760Davis Robby E · Plant City, FLBuilt 1969 · S/N 30-1999N3876DBurns William Greg · Eloy, AZBuilt 1958 · S/N 34839N3876PBreen George R · East Falmouth, MABuilt 1956 · S/N 18-4702N3876QKracke Spraying Service Inc · Fargo, NDBuilt 1971 · S/N 17259976N3876VKramer William L · Big Lake, AKBuilt 1981 · S/N 18504167N3876WSteele Kyle Z · Acworth, GAS/N 32-822N3876XFlying Weenie LLC · Henderson, TXBuilt 1967 · S/N 175N38771Bmaf LLC · Lewes, DEBuilt 1977 · S/N 28R-7737116N38773Gustafson David · Watertown, SDBuilt 1977 · S/N 28R-7737117N38777Medsker Doug S · Graham, MOBuilt 1977 · S/N 28-7816181N3877PBranson Derrick · Seward, AKBuilt 1955 · S/N 18-4703N3877YGonzo LLC · La Junta, COS/N 21058377N3877ZAlsworth John H · Anchorage, AKBuilt 1961 · S/N 18-7668N38786Johnson David M · South Deerfield, MABuilt 1977 · S/N 28-7790588N3878TRoach Keith E · Chester, SCBuilt 1967 · S/N 28R-30203N3878YRegistered aircraftBuilt 1964 · S/N 21058378N3878ZWorrell Trevor S · Anchorage, AKBuilt 1961 · S/N 18-7672N3879DHolberton George L · White City, ORBuilt 1957 · S/N 34579N3879MMcgowan Patrick Joseph · Troutdale, ORBuilt 2010 · S/N 81094N3879PZimmer Chris P · Upham, NDBuilt 1955 · S/N 18-4705N3879RFox Pond Farm · Indian Trail, NCFirst renewal noticeBuilt 1970 · S/N 28-5851N3879TDupuis Kevin P · Waddell, AZBuilt 1967 · S/N 28R-30204N3879WSale Reported · Texarkana, TXSale reportedBuilt 1966 · S/N 32-825N3879ZNelson Chad A · Buffalo, SDBuilt 1961 · S/N 18-7677N387AFCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 2006 · S/N 172S10387N387CSDa Aviation LLC · Englewood, COBuilt 2011 · S/N 18282287N387DCDyncorp International Inc · Mcclellan, CABuilt 2021 · S/N 172S12652N387J387j LLC · Scotts Hill, TNBuilt 2005 · S/N 1389N387JKTaylor Jason E · Keller, TXBuilt 1980 · S/N E-1638
Back to AD 2007-04-19 R1