OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N15BREllis David E Jr · Midlothian, TXBuilt 1978 · S/N 32R-7880004N15CBAaviation LLC · Telford, PABuilt 1976 · S/N 28R-7635291N15CHOrlando Flight Academy Inc · Apopka, FLBuilt 1974 · S/N 28-7415277N15CKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1985 · S/N 10012CN15CLDoran Jeffrey T · Westerville, OHS/N TC-818N15CMCarolina Aero Group LLC · Youngsville, NCBuilt 2004 · S/N 2280N15CWN15cw LLC · Wilmington, DEBuilt 1983 · S/N P21000824N15CXKlausman Branin W · Mascoutah, ILBuilt 2003 · S/N 0451N15CZSafe Aero LLC · Fort Myers, FLBuilt 2005 · S/N 72N15DEVlazny Stephen F · Divide, COBuilt 1992 · S/N 1N15DLSchlund Bradley D · Springtown, TXS/N CD-375N15DMFowler Bruce Jr · Cedar Park, TXBuilt 1955 · S/N G-702N15DNSnowflake Aircraft LLC · Fayetteville, NYBuilt 1989 · S/N E-2472N15DQPrivette Hugh T Trustee · Colorado Springs, COBuilt 1975 · S/N 75-30773N15DRTufco Flooring Delmarva Inc · N Chesterfield, VABuilt 2002 · S/N 0394N15DSAll Attitude Aviation Inc · Edgewater, FLBuilt 1965 · S/N 320D0079N15DTBernal Cresencio · Pittsburg, CABuilt 1968 · S/N D-8725N15DVJoiner Robert W · Worton, MDS/N SDV-RJ-02N15EMBranson Tristan · Etna, CABuilt 1972 · S/N 207N15ESCyr Gregory A · Augusta, MEBuilt 1988 · S/N 001N15ETGfeller Steve · Thornton, WABuilt 2008 · S/N CC18-0026N15EXRich David R · Glastonbury, CTS/N 5496N15FGarvin Neal R · Avon, CTBuilt 1997 · S/N 001N15FACivil Air Patrol · Maxwell Afb, ALBuilt 1978 · S/N 17270117N15FBPropit Inc · Wilmington, DES/N 018N15FPFoxtrot Papa LLC · Slidell, LABuilt 1977 · S/N 17268574N15FYEsselme Aeronautics & Astronautics LLC · Annapolis, MDBuilt 2006 · S/N 71328N15GFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2019 · S/N 3324N15GK427 Siera Lima LLC · Ponte Vedra, FLBuilt 1974 · S/N TC-1681N15GLTubb Jeffrey Scott · Farmington, NMBuilt 2016 · S/N 1209N15GMBristol Aviation De LLC · Wilmington, DEBuilt 1995 · S/N E2977N15GVCloud 916 LLC · Dover, DEBuilt 2000 · S/N 1297-2000N15GWFlight Brothers LLC · Sachse, TXBuilt 1969 · S/N 17258161N15HCMvp60 Fly High LLC · Boca Raton, FLBuilt 2014 · S/N E-4032N15HJMorehouse Cooper · North Pole, AKS/N 17268950N15HPCoastal Helicopters Inc · Ocracoke, NCBuilt 2016 · S/N 14018N15HSF S Enterprises LLC · Oakland Park, FLBuilt 2020 · S/N E-4143N15HUBratton Gary · Poteau, OKBuilt 1996 · S/N 1318N15HYS&S Aviation LLC · Oakley, UTS/N 3328N15JAAdams Harry Jay · New Waverly, TXBuilt 1979 · S/N TK95N15JDSwanson Alec · Hanahan, SCBuilt 1972 · S/N 310Q0476N15JEPremier Flight Center LLC · Hartford, CTBuilt 1964 · S/N 27-2494N15JUC&D Aviation LLC · Appleton, WIBuilt 1982 · S/N TJ-434N15JWTri-Cap International · Roanoke, TXBuilt 1959 · S/N TD-225N15KFH Aviation LLC · Celina, TXBuilt 1980 · S/N 32-8006073N15KYMcdougle Sean · Oklahoma City, OKBuilt 1965 · S/N 27-2780N15LFNorthrup George William · Ellicottville, NYBuilt 1998 · S/N 1395N15LRBoggs James A · Tucson, AZBuilt 1994 · S/N 1309N15LSArch Air LLC · Paducah, KYBuilt 1972 · S/N TC-1465N15LWIsaak Robert J · Pocatello, IDBuilt 2001 · S/N 90016
Back to AD 2007-04-19 R1