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.

N4837DRees Matt A · Spokane, WABuilt 1958 · S/N 34937N4837FWesellairplanes Com Inc · Wilmington, DEBuilt 1976 · S/N 28-7715071N4837LNavarro Ricky L · Riverview, FLBuilt 1967 · S/N 28-4181N4837SJrf Aircraft LLC · Maple Shade, NJBuilt 1969 · S/N 32-1266N4837URegistration Pending · Kerrville, TXRegistration pendingBuilt 1964 · S/N 205-0537N4838Fajardo Mark A · Longmont, COBuilt 1975 · S/N KB-1N4838FThomason Booker T Jr · Chicago, ILBuilt 1976 · S/N 28-7715072N4838KCommercial Tenant Improvement Corp · Alta Loma, CABuilt 1979 · S/N P21000341N4838LSandstrom David E · Anchorage, AKBuilt 1967 · S/N 28-4182N4838SDairy Air LLC · Lake Jackson, TXBuilt 1970 · S/N 32-1267N4838TSnow Leopard Ltd · Incline Village, NVBuilt 1981 · S/N R18201774N4838YWagner Nathan D · Dane, WIBuilt 1968 · S/N 25-4634N4839DRosecrans Robert · Emmett, IDBuilt 1958 · S/N 34939N4839GPaw Lifter Aero LLC · Madison, INBuilt 1979 · S/N 17273386N4839JFlying For Fun LLC · Sunnyvale, TXBuilt 1966 · S/N D-8340N4839LStandard David W · Toccoa, GABuilt 1967 · S/N 28-4183N4839WPiscoya Thomas G · Anchorage, AKBuilt 1989 · S/N 1809012N483ACTessos Air Service Inc · Wilmington, DEBuilt 1999 · S/N 1282-99N483DMN483dm LLC · Hummelstown, PABuilt 1975 · S/N 21060819N483EAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 17273688N483EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12254N483FLOliver Zachary J · Seligman, AZBuilt 1971 · S/N 28-7125291N483JFKg Aviation LLC · Huntington, WVBuilt 1974 · S/N 414-0537N483NMCao Roger · Tomball, TXBuilt 2001 · S/N 3250N483RVCoverstone Timothy L · Bellemont, AZBuilt 2004 · S/N 70175N483SPScandinavian Aviation Academy Inc · El Cajon, CABuilt 1998 · S/N 172S8029N483TClr Aviation LLC · Wilmington, DEBuilt 1961 · S/N CD-314N4840LIrons Eric P · Enoch, UTBuilt 1967 · S/N 28-4186N4840TRegistered aircraftS/N R18201775N4840YDmc Aircraft LLC · Naples, FLBuilt 1968 · S/N 25-4637N4841CTreftz Kurt B · Anacortes, WAS/N 18502609N4841DDoorglobe Inc · San Francisco, CABuilt 1979 · S/N 17272371N4841FVidhun Raghuraman R · Southbury, CTBuilt 1976 · S/N 28-7790067N4841LPapa India Echo Inc · Chambersburg, PABuilt 1967 · S/N 28-4187N4841NRegistration Pending · Columbus, OHRegistration pendingBuilt 1979 · S/N 18267411N4841RBlack Gulch Aviation LLC · Polson, MTBuilt 1975 · S/N 18802360TN4841SPuerto Rico Aircraft Leasing Corp · Ceiba, PRBuilt 1969 · S/N 32-1270N4841YBlack Forest Soaring Society · Monument, COS/N 25-4639N4842AHill Steven Douglas · Stoneville, NCBuilt 1956 · S/N 22-3995N4842DTablerock Cattle Co LLC · Lacrosse, WABuilt 1958 · S/N 34942N4842JTayrien Jacob A · Queen Creek, AZBuilt 1966 · S/N CE-123N4842KKinetic Group LLC · Eagle, IDBuilt 1979 · S/N P21000343N4842QBlack Gulch Aviation LLC · Polson, MTBuilt 1976 · S/N 18802578TN4842THampsten Jacob Clay · Mesquite, NVS/N 28-7225222N4842UMadsen Gerald H · Seattle, WAFirst renewal noticeBuilt 1964 · S/N 2050542N4843ANous Air LLC · Yukon, OKBuilt 1956 · S/N 22-3996N4843CPayne Thomas E · Old Forge, NYBuilt 1975 · S/N 18502611N4843PSherrill L H · Tucson, AZBuilt 1961 · S/N 27-414N4843RFriesenborg & Larson Custom Spraying Lc · Buffalo Center, IABuilt 1975 · S/N 18802362TN4843THuizenga Jamie L · Pierre, SDBuilt 1972 · S/N 28-7205205
Back to AD 2007-04-19 R1