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.

N38914Acadian Aviation Pilot Training Centre Inc · Lafayette, LABuilt 1977 · S/N 28-7716291N38919Sale Reported · Sarasota, FLSale reportedBuilt 1977 · S/N 28R-7737123N3891CStaple K Aviation LLC · Queen Creek, AZBuilt 1954 · S/N 31039N3891QRiley George L III · Washington, INBuilt 1971 · S/N 17259991N3891TJones Rodney D · Corcoran, CABuilt 1967 · S/N 28R-30220N3891YCartwright Chris · Yuba City, CABuilt 1964 · S/N 21058391N3891ZLaudon Sydney L · Anchorage, AKS/N 18-7707N3892DWeiss Steven John · Las Vegas, NVBuilt 1957 · S/N 34592N3892KRowley Rodney N · Duchesne, UTS/N 28-23763N3892NNeed For Speed Inc · Dover, DEBuilt 1968 · S/N 680145N3892QKcn Aero Club Inc · Overland Park, KSS/N 17259992N3892ZWinston Christopher C · Vancouver, WABuilt 1961 · S/N 18-7708N3893Rhynard Andrew · Fairbanks, AKBuilt 1958 · S/N 50246N3893CCravens Robert A · Bend, ORBuilt 1954 · S/N 31041N3893DGardner Jay A · Agua Dulce, CABuilt 1957 · S/N 34593N3893QSisung Ty J · Roxie, MSBuilt 1971 · S/N 17259993N38945Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 32R-7780490N3894CWatson Philip D · Wheatland, INBuilt 1954 · S/N 31042N3894FNorth Shore Aero Club · Beverly, MABuilt 1976 · S/N 28-7690459N3894TBsa Leasing LLC · Pocatello, IDBuilt 1967 · S/N 28R-30223N3894WElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1966 · S/N 32-840N38952Ponto Phillip R · Vista, CABuilt 1977 · S/N 28-7716297N38954Faulkner Wade DBA · Sterrett, ALBuilt 1977 · S/N 28-7716299N3895FGreever Steven M · Spearman, TXBuilt 1977 · S/N 28R-7737002N3895GMike Kilo Aviation LLC · Garden Ridge, TXBuilt 1967 · S/N U206-0895N3895TPaetzold Carson · Jacksonville, FLBuilt 1967 · S/N 28R-30224N38968Vagabond Flying Association · Winfield, ILBuilt 1977 · S/N 28-7716300N38969Vandervelden Harmen J · Ware, MABuilt 1977 · S/N 28-7716301N3896DMills Air Service Inc · Marstons Mills, MABuilt 1957 · S/N 34596N3896FEssary Larry R · Mc Neal, AZS/N 28R-7635376N3896GEco Flite Service Inc · Lake Elsinore, CABuilt 1967 · S/N U206-0896N3896QNishna Valley Flying Club · Red Oak, IABuilt 1971 · S/N 17259996N3896ZDriggs Daniel H · Anchorage, AKBuilt 1961 · S/N 18-7674N38970Triple R Aviation LLC · Cleburne, TXBuilt 1977 · S/N 28-7716302N38972August Aero LLC · Kalispell, MTS/N 28-7716304N38974International Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 28-7716305N3897CKing Bruce J · Waldport, ORBuilt 1954 · S/N 31045N3897XRegistration Pending · Greenwood, INRegistration pendingBuilt 1967 · S/N 134N3897YHmw LLC · Wilmington, DEBuilt 1964 · S/N 21058397N3897ZWard Joseph Delon · Wasilla, AKS/N 18-7788N38984Registered aircraftS/N 32R-7780495N38986Ascend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 28-7716306N38987Ocean City Flying Club LLC · Middletown, RIBuilt 1977 · S/N 28-7716308N38988Bms Aircraft LLC · Tinley Park, ILBuilt 1977 · S/N 28-7716309N38989M5 LLC · Kit Carson, COBuilt 1977 · S/N 28-7716310N3898QJaynes Grayson V Sr · Burnet, TXBuilt 1971 · S/N 17259998N3898XWood Noah S · New Manchester, WVBuilt 1967 · S/N 138N3898ZTtyf LLC · Hood River, ORBuilt 1960 · S/N 18-7343N38990Augusta Aviation Inc · Hilton Head Island, SCBuilt 1977 · S/N 28-7890002N38996Cherokee Kling LLC · Monroe, CTBuilt 1977 · S/N 32-7740104
Back to AD 2007-04-19 R1