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.

N170QCherry Calvin L · Paso Robles, CABuilt 1978 · S/N 1137N170RBChristiansen Aviation LLC · Wilmington, DES/N 172S11130N170RCCbp Air Logistics LLC · Statham, GABuilt 2008 · S/N E-3829N170SKNottingham John F · Covington, LABuilt 1979 · S/N 17273173N170SPSweatt Jeffrey · West Terre Haute, INBuilt 1981 · S/N 17275097N170TDHoyt Nicholas J · Port Orchard, WABuilt 1954 · S/N 26488N170WTBarber Shane C · Willow, AKS/N 12-753N17102North Timothy · Milton, WVBuilt 1976 · S/N 17702503N1710ABald Mtn LLC · Modesto, CABuilt 2016 · S/N TH-2462N1710CSmith Peter R · Lewistown, MTBuilt 1953 · S/N 30410N1710GNational Test Pilot School · Mojave, CAS/N 18282011N1710HQuon Nicholas · Fayetteville, GABuilt 1959 · S/N 35810N1710JOpen Skies Aviation LLC · Wellington, KSBuilt 1968 · S/N 28-24119N1710KCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13178N1710TGarretson Thomas A · New Smyrna Beach, FLBuilt 1970 · S/N 28-7125025N1711CNorthern Flyway LLC · Anchorage, AKBuilt 1953 · S/N 30411N1711DSterling Douglas J · Hadley, NYBuilt 1999 · S/N 5230N1711TLeadturn LLC · San Diego, CABuilt 1976 · S/N 28-7610075N1711VAggravation Aviation Inc · Wilmington, DEBuilt 1964 · S/N TC-591N1711WBogaard Jeffery D · Kansas City, MOBuilt 1966 · S/N 18257108N1712CGrant Douglas E Jr · Chubbuck, IDBuilt 1953 · S/N 30412N1712HColvin Clu D DBA · Big Cabin, OKS/N 35812N1712JTwelvejuliet LLC · Moberly, MOBuilt 1968 · S/N 28-24123N1712QMischief Makers LLC · Tuscaloosa, ALBuilt 1971 · S/N 15073012N1712SNorth Carolina Dept Of Enviroment & Natural Resour · Raleigh, NCBuilt 2005 · S/N 18281620N1712TLea Joe A · Mason City, IABuilt 1970 · S/N 28-7125026N17132Harvey Laurence C · Lincoln, NEBuilt 1982 · S/N R18201921N17137Miller Scott · Albia, IABuilt 1976 · S/N 17702506N1713CAir-Spacers Inc · Santa Monica, CABuilt 2007 · S/N 18282013N1713GRight Away Trucking Inc · Hazlehurst, GABuilt 1962 · S/N D-6939N1713JSimpson Mark E · Fairbanks, AKBuilt 1968 · S/N 28-24124N1713RNevada General Enterprises Ltd · Reno, NVBuilt 1978 · S/N R18200530N1713VGrasshopper Flying Club · Poughkeepsie, NYBuilt 1974 · S/N 17263721N1714210ds Ltd · Centreville, VABuilt 1976 · S/N 17702507N1714BGreat Plains Aero Inc · Tolley, NDBuilt 1976 · S/N 18-7609109N1714CMoreau Aviation LLC · Wasilla, AKS/N 30414N1714GBull Rises LLC · Byron Center, MIS/N CD-482N1714JFernandes Gary DBA · Clallam Bay, WABuilt 1968 · S/N 28-24126N1714TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12050N1715CAerotrack Inc · Hemet, CABuilt 1953 · S/N 30415N1715TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12051N1715WDlh Aviation LLC · Sainte Genevieve, MOBuilt 1972 · S/N CD-1301N1715YPacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7654096N1716CReidenbach John S · Kenosha, WIBuilt 1953 · S/N 30416N1716EMccaskill William L · Hampton, VABuilt 1978 · S/N 310R1547N1716JNess Brian · Wasilla, AKBuilt 1968 · S/N 28-24128N1716PJones Gary L · Kerrville, TXBuilt 1954 · S/N 22-2506N1716RRegistration Pending · Krum, TXRegistration pendingBuilt 1978 · S/N R18200531N1716TStratus Business Development LLC · Nashua, NHBuilt 1970 · S/N 28-7125030N1716XBell Brian · Oakland, CABuilt 1975 · S/N 21060738
Back to AD 2007-04-19 R1