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.

N33691Wide Open Aviation LLC · Kalispell, MTBuilt 1975 · S/N 28-7525227N33692Horn Justin L · Hearne, TXBuilt 1975 · S/N 28-7505170N33694Fly LLC · Natchez, MSBuilt 1975 · S/N 32-7500029N33698Briggs Michael L · Howell, MIBuilt 1975 · S/N 28R-7535181N3369ERustmann Richard E · Willimantic, CTBuilt 1978 · S/N 17271520N3369FJ P Aero Holdings Inc · Carson City, NVS/N 18257369N3369RFenton Flyers Inc · Hillsboro, MOBuilt 1967 · S/N 18258669N3369SC-210 Lc · Atlantic, IABuilt 1969 · S/N 21059169N3369TBauer Charles · Graceville, MNS/N 17700669N3369WBlue Sky Aviation LLC · Attleboro, MABuilt 1968 · S/N 32-1054N3369XCollins Jerod William · Conifer, COBuilt 1966 · S/N 1088N336AFLaine Carey E · Nevada City, CABuilt 1972 · S/N 17260404N336APJsb Investments LLC · Morristown, TNBuilt 2012 · S/N E-3977N336BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881098N336BWAllen Scott L · Ogallala, NEBuilt 2001 · S/N 4352N336CABergeron Machine Shop Inc · Abbeville, LABuilt 1998 · S/N EA613N336CBBeechair LLC · Helena, MTBuilt 2002 · S/N E-3431N336DBGustafson Gary E · Motley, MNBuilt 2005 · S/N 90805N336EDAdvanced Therapy Products Inc · Richmond, VABuilt 2013 · S/N 13461N336FSRobinson Charles M Sr · Niceville, FLBuilt 2004 · S/N 14N336HPChs Acquisitions Inc · Dallas, TXBuilt 1989 · S/N CE1312N336JALundquist Eric John Jr · Houston, TXBuilt 2003 · S/N 81392N336LMKlm Unlimited Inc · Staples, MNS/N E-1587N336MAHot Wings Aviation LLC · Fishers, INBuilt 2024 · S/N 28020175N336MCLewis University · Romeoville, ILBuilt 2022 · S/N 172S12880N336MKNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881087N336MTNorth Peak Aviation LLC · Waunakee, WIBuilt 1999 · S/N E-3265N336NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2007 · S/N 120MN336NANickravesh Niknam J · Saratoga, CABuilt 1980 · S/N E-480N336PAWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 4496140N336PWCajan LLC · Kings Mountain, NCBuilt 1982 · S/N EA-297N336RABrown Donald B · Virginia Beach, VABuilt 1978 · S/N 3098N336RDByone Steve · Natchitoches, LABuilt 1996 · S/N E-3008N336RVVose Kristin M · Bloomington, ILBuilt 2001 · S/N 60199N336RWBe5816 LLC · Simi Valley, CABuilt 2005 · S/N E-3636N336SQla Air LLC · Fort Myers, FLBuilt 2013 · S/N E-3989N336SBPieternelle J Coffy · Beaumont, TXBuilt 1973 · S/N 28-7305489N336SGAndrade South Florida Services Inc · Plantation, FLS/N 1336N336TTophatter85 LLC · Kirksville, MOBuilt 1978 · S/N E-1219N336VRobertson Ryan T · Richmond, VABuilt 1979 · S/N 79-31155N336WTRomney Chad · Rigby, IDBuilt 2023 · S/N 1210-2023N336ZGoodman Michael R · New Brighton, PABuilt 1960 · S/N D-6489N3370SWittenborn Grant A · Olathe, KSBuilt 1973 · S/N 18502281N3370UBriannas Wings Of Passion Foundation Inc · Magalia, CABuilt 1963 · S/N 18254770N3370WRaddohl Garret L · New London, MNS/N 32-216N3370YBrink Brittnie L · Baldwin, WIBuilt 1962 · S/N 18254370N33715Wdc Enterprises LLC · Beaumont, TXBuilt 1975 · S/N 28-7525231N3371EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271521N3371FRavens Rebuilders Inc · Ellenboro, WVS/N 18257371N3371LAgresti Harold David · Ceres, CABuilt 1967 · S/N 185-1323
Back to AD 2007-04-19 R1