OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,433

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.

N2198GAirstar Aviation Inc · Chester, SCBuilt 1958 · S/N 51498N2198PAerotrack Inc · Hemet, CABuilt 1956 · S/N 23-808N2198ROlson Darryld A · Buckley, WAS/N 18255398N2198SPeavey Brian H · Houston, TXBuilt 1979 · S/N R18201314N21992Gilpin Sean F · Madison, ALBuilt 1978 · S/N 32R-7885265N2199CMorris Thomas B · Imlay City, MIBuilt 1958 · S/N 38081AN2199GEmery Craig A · Wasilla, AKBuilt 1958 · S/N 51499N2199LCardamone-Rayner Mark · Manistique, MIBuilt 1976 · S/N E-968N2199PPowers Edward · Stormville, NYS/N 23-809N2199TKeith Brothers Aviation LLC · Fort Worth, TXBuilt 1971 · S/N 28-7205051N2199UWood James DBA · Memphis, MOS/N 18800799N219AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843788N219BJTaylor Kennedy E · Courtland, MSBuilt 1967 · S/N 28-22813N219CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13080N219CDCd Flyers LLC · Port Orange, FLBuilt 2001 · S/N 1124N219CEGillison William · Lake Village, ARBuilt 2023 · S/N 18283219N219CFJohnson Francis W · Krugerville, TXS/N 44BF02N219CHSteel Eagle Aviation LLC · Birmingham, ALBuilt 2001 · S/N TH-1990N219CRHot Fat Helo LLC · Hampton, NHBuilt 2016 · S/N 13992N219DBN219db LLC · Bryan, OHBuilt 1966 · S/N 28-2970N219DCMjz Ventures LLC · Dodge City, KSBuilt 2023 · S/N 11180026N219DGCtrl Electrical LLC · Lexington, NCBuilt 1999 · S/N 3246134N219DSJojo & Dino Ltd · Frederick, MDBuilt 2002 · S/N 40.219N219EAMusante Keith · Heber City, UTBuilt 2023 · S/N PX1520029N219EPEpic Aviation Inc · New Smyrna, FLBuilt 2019 · S/N 4496458N219GMStewart Michael A · Washington, DCBuilt 1988 · S/N TH-1536N219JHNelson Jack L · Corinth, TXBuilt 1968 · S/N CD-1184N219JRRoberts Pipeline Inc · Middletown, INBuilt 1973 · S/N 28-7410026N219LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeBuilt 2006 · S/N 11219N219MCHansen Todd · Friday Harbor, WABuilt 2004 · S/N 18281323N219MLGelbard Dustin S · Lake Havasu City, AZBuilt 1966 · S/N TE-243N219PBChoptera LLC · Odem, TXBuilt 2019 · S/N 24960N219PDWolfair LLC · Lewes, DEBuilt 2005 · S/N 18281665N219QBoe John · Langdon, NDBuilt 1965 · S/N D-7790N219RPMorrow Dennis J · Houston, TXBuilt 1976 · S/N E-885N219RTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2003 · S/N 2189N219RVMcguff Thomas M Trustee · Olathe, KSBuilt 2010 · S/N 91521N219SPLouisville Aircraft Leasing LLC · Louisville, KYBuilt 1999 · S/N 172S8219N219STLti LLC · Incline Village, NVBuilt 2009 · S/N 12537N219TBAir Fins LLC · Wilmington, DEBuilt 2007 · S/N TH-2197N219THP Hiliarde Enterprises · Salida, COBuilt 1951 · S/N 22611N219WEFinnegan Dennis M · Novato, CABuilt 1994 · S/N 1695N219WYWolding Mylo · New Town, NDBuilt 2014 · S/N 3219N219ZCarroll Sean Terence · Saint Petersburg, FLBuilt 1964 · S/N TC-789N21ADBogart Donald W Jr · Long Beach, CABuilt 1961 · S/N 18253313N21AHHarris Paul Andrew · Cheyenne, WYS/N 1961N21AJAllcroft Roger A · Haydenville, MAS/N 754N21ARClarkson Jeffrey D · Park Rapids, MNS/N 755N21ASBoa Properties LLC · Valdosta, GABuilt 1968 · S/N 28R-30862N21ATMeadville Aero Club LLC · Erie, PABuilt 1977 · S/N 17268907
Back to AD 2007-04-19 R1