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.

N44LMDelpenn Flyers Inc · Dover, DEBuilt 1981 · S/N 18268030N44LNBrown Bear Air Inc · Anchorage, AKBuilt 2005 · S/N 10848N44LRRouse Peter L · Parkville, MOBuilt 1996 · S/N 1N44LTLonderville Ross G · Stanwood, WABuilt 1984 · S/N 348N44LUGresham Thomas H · Cascade, IDBuilt 1979 · S/N 18267355N44MPMiller Dennis Joseph · Bartlett, TNBuilt 1969 · S/N TE-760N44MTFree Fliers Ma LLC · Sheridan, WYS/N G-11N44NFPeak Aviation LLC · Ashland, ORBuilt 2012 · S/N 3151N44NKNist Joseph Anthony II · Pittsburgh, PABuilt 1968 · S/N TE-470N44NPInternational Air Services Inc Trustee · Carson City, NVBuilt 2000 · S/N 14679N44NTTucker Nicholas B · La Canada, CABuilt 1981 · S/N 21064531N44NVAg Flite Specialties LLC · Williston, NDS/N 11800N44PAN44pa LLC · Boca Raton, FLBuilt 2021 · S/N 14493N44PBMcpeck Adam S · Agar, SDFirst renewal noticeBuilt 1964 · S/N D-7678N44PEJanssen Willis W · Ault, COBuilt 1957 · S/N D-5169N44PFVaayu Aviation LLC · Newark, CABuilt 1970 · S/N 28-26800N44PGSimon Jevon D · Buckley, WABuilt 1999 · S/N 2522-001N44PHHatch Fletcher A III · Vero Beach, FLBuilt 2002 · S/N 0002N44PJSchaufenbuel Todd W · Imperial, NEBuilt 1992 · S/N 1209N44PPKnr Inc · Evanston, WYBuilt 1955 · S/N 22-2576N44PWWeber Peter III Trustee · Loudon, TNBuilt 1979 · S/N 28-8090147N44PYSegler Angela U · Marco Island, FLBuilt 2000 · S/N 172S8543N44PZRegistered aircraftBuilt 1998 · S/N 29-0135N44QGraf Erwin · Clayton, NCBuilt 1974 · S/N 446N44QQEastern Stearman Inc Trustee · Leesburg, VABuilt 2000 · S/N 6034N44RAJohnson Bruce W · Portland, ORBuilt 1965 · S/N TC-916N44RBAmj Air LLC · Holland, MIBuilt 1973 · S/N 18261829N44RRRichardson Robert L · Rch Palos Vrd, CABuilt 1985 · S/N R-1N44RTWinkelman Dan · Bethel, AKBuilt 1971 · S/N 18-8927N44SAGniks LLC · Nevada, MOBuilt 1978 · S/N TJ-167N44SBReid Larry Paul · Jasper, GABuilt 1971 · S/N CE-356N44SDKandle Douglas A · Boise, IDBuilt 2015 · S/N TCQ1007068N44SJHarpreet Sandhu · Livermore, CABuilt 1977 · S/N 0752N44SKCm3 LLC · North Las Vegas, NVBuilt 2004 · S/N 10534N44SPAwh Ventures Inc · Houston, TXBuilt 1975 · S/N TE-1036N44STTakvorian Sevag · West New York, NJBuilt 1979 · S/N 17271609N44TCKinzie Hon K · Anchorage, AKBuilt 2002 · S/N 9941CCN44TDChristian Joe L · Naylor, GABuilt 1973 · S/N 1000N44TEThomaston Bonanza Club Inc · Thomaston, GABuilt 1975 · S/N E-796N44TGBlue Water Flying Services LLC · Lumberton, TXS/N 0509N44TLEco-Logic Environmental Engineering Inc · Placentia, CABuilt 1979 · S/N 80-30973N44TUOglesby John B · Graford, TXBuilt 1978 · S/N 18503616N44TWRotor Leasing LLC · Indianapolis, INBuilt 2025 · S/N 14824N44UBPlane Fun Inc Tr Trustee · Snellville, GABuilt 2006 · S/N 11194N44UDB & K Aviation LLC · Danville, CABuilt 2017 · S/N 172S12072N44UGNomadic Aviation LLC · Sheridan, WYBuilt 1991 · S/N 10088CN44UHAlba Leasing Services LLC · Scottsdale, AZBuilt 2015 · S/N 4677N44UKN44uk Partners LLC · Burlington, WABuilt 2005 · S/N 10969N44VBColeman Jack L · Monroe City, MOBuilt 1978 · S/N CE-760N44VFLorenz Reiff A · Dayton, OHBuilt 2007 · S/N 3FX023
Back to AD 2007-04-19 R1