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.

N5697ERedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N 17271922N5697JRidgway Rick J · Carlisle, INBuilt 1970 · S/N 18800647N5697KMerimont Aviation LLC · Dyersburg, TNBuilt 1964 · S/N D-7620N5697QReed Timothy W · Terrell, TXBuilt 1965 · S/N 815N56986Loya Armando · Whittier, CABuilt 1973 · S/N 28-7425079N56987Ravotti Air LLC · Leechburg, PABuilt 1973 · S/N 28-7415032N56988Hillerman Paul J · Vinita, OKBuilt 1973 · S/N 28-7415033N56989Kenny Zachary D · Herndon, VABuilt 1973 · S/N 28-7405040N5698BTilley Melvin D · Sperry, OKBuilt 1956 · S/N 33698N5698KSmith Ronald E · Jefferson, TXBuilt 1964 · S/N D-7622N5698QCaughell David S · Bartlesville, OKBuilt 1965 · S/N 705N5698SNewell Gary A · Colmar, PABuilt 1966 · S/N MA-102N5698UNorby David S · Gooding, IDS/N 28-26495N5698WBurkett Aviation LLC · Hampstead, NCBuilt 1963 · S/N 28-1094N56991Schneider Stephen C · Denton, TXBuilt 1973 · S/N 28R-7435070N56992Attebery Larry J · Caldwell, IDBuilt 1973 · S/N 28R-7435071N569932c Fun Aviation LLC · Dallas, TXBuilt 1973 · S/N 28-7410040N56996Zarn Douglas J · Amboy, MNBuilt 1973 · S/N 28-7425080N56997Bibb John G · Paragould, ARBuilt 1973 · S/N 28-7425081N56999Lofty Images LLC · Owosso, MIS/N 517N5699DClear Lake Management Corp · Wilmington, DEBuilt 1981 · S/N 510N5699KMoore Joseph M · Santa Barbara, CABuilt 1964 · S/N D-7603N5699NStyer David B · Pendleton, ORBuilt 1981 · S/N 1220N5699PHahn Curtis D · St George, UTBuilt 1959 · S/N 24-772N5699ULrh Equipment LLC · Pendleton, ORS/N 511N5699VMesmer Robert F · Grand Island, NYBuilt 1981 · S/N 512N569ARN717dz LLC · Lovell, WYS/N 18267746N569BSZanetta Wayne T · Portland, ORBuilt 2014 · S/N 18-1686N569CDUltimate Holdings LLC · La Grande, ORBuilt 2008 · S/N 12257N569CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 18283071N569DPHale William J · Whitehouse, TXBuilt 2008 · S/N 90707N569DWBranched Oak Charter LLC · Rising City, NEBuilt 2019 · S/N 14331N569FGMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10871N569FLN7396w LLC · Coeymans Hollow, NYS/N 28-7125413N569JMInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 414A0425N569KCross Timbers Aviation LLC · Bedford, TXBuilt 1999 · S/N 30-0026N569MKindred Daniel P · Jacksonville, ILFirst renewal noticeS/N 20-0009N569MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.314N569NDVertol Systems Co Inc · Destin, FLBuilt 2009 · S/N 172S11004N569PKWorld Aircraft Inc · Wagener, SCBuilt 2018 · S/N 14232N569RHEvans Lawrence · Ocala, FLBuilt 2011 · S/N 71613N569RVRicketts Michael D · Weirsdale, FLBuilt 2010 · S/N 91519N569SPGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 2000 · S/N 172S8494N569TCGablin Theodore J · Calimesa, CABuilt 2009 · S/N 71971N569TJAnderson Thomas C · Poplar Grove, ILBuilt 2013 · S/N 259RN569TLRotermund Brett L · Fairbanks, AKBuilt 2013 · S/N 13559N569TSBig South Fork Aero Inc · Huntsville, TNBuilt 1993 · S/N 722-93N569WHGp Cub Air LLC · Sioux Rapids, IABuilt 1965 · S/N 18-8271N56ABBezanson Adam M · Fremont, NHBuilt 2024 · S/N 41687N56AKLonghorn Leasing LLC · Anchorage, AKS/N U20605353
Back to AD 2007-04-19 R1