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.

N1475VGlobal Flight Training Solutions Inc · Immokalee, FLS/N 17263610N1476251 Adventures LLC · East Montpelier, VTS/N 74-30649N14764Bl14764 LLC · Homer, LABuilt 1974 · S/N 74-30701N1476JDodgen Charles W · Thomaston, GABuilt 1976 · S/N 476N1476SBk1 Farms LLC · Rock Port, MOBuilt 1976 · S/N 18265023N1476TBough Jayce K · El Dorado Hills, CAS/N 28-7225530N1476UTampa Bay Aviation Inc · Clearwater, FLBuilt 1976 · S/N 17267143N1476XAbel Adam T · Aberdeen, OHS/N 28-7525309N14771Shiner Aviation LLC · Georgetown, TXBuilt 1974 · S/N 75-30732N14772Koehn Loren M · Galva, KSBuilt 1974 · S/N 74-30691N1477GDobson John F · Union, WABuilt 1962 · S/N D-6980N1477TSrh Club Inc · Wilmington, DEBuilt 1972 · S/N 28-7205306N1477VSatermo Lee John · New Town, NDBuilt 1974 · S/N 17263612N1477XRed Rock Flying School LLC · Mesa, AZBuilt 1975 · S/N 28-7525313N14782Roberts James B · Piedmont, OKS/N 74-30629N14783Braddock Zachary J · Ladson, SCBuilt 1973 · S/N 74-30640N14786Registered aircraftBuilt 1973 · S/N 74-30651N1478MWestern Wind Aviation LLC · Suisun City, CABuilt 1975 · S/N 18264343N1478XMello Edward R Jr · Land O Lakes, FLBuilt 1975 · S/N 28-7525292N14792Ripley James Jefferson III · Frederick, OKS/N 74-30645N14793Clinton M Ward Pc · Vinita, OKBuilt 1974 · S/N 74-30708N14798Ingle Stephen D · Bainbridge, OHBuilt 1974 · S/N 74-30675N1479CBuilt Aviation LLC · Haymarket, VABuilt 1977 · S/N 17702735N1479EAero Capital Lending LLC · Miami, FLBuilt 1978 · S/N 17271016N1479JAbel Paul D · Kalispell, MTS/N 539N1479TWnc Aviation LLC · Arden, NCBuilt 1972 · S/N 28R-7235302N1479USperoni Pablo · Vieques, PRBuilt 1976 · S/N 17267146N1479XDunn Michael J · Nashua, NHBuilt 1975 · S/N 28-7515411N147AVRegistered aircraftN-number assigned, not yet registeredS/N 1262N147BMarble Jacob G · Sandpoint, IDBuilt 2019 · S/N 081 SRN147BCCard Logging Co Inc · Eugene, ORFirst renewal noticeBuilt 2003 · S/N 447-2003N147BDNageotte Randy K · Fredericksburg, VABuilt 2003 · S/N 70388N147BRVaccaro Michael J · Niceville, FLBuilt 1995 · S/N 2112N147CVAmparan Robert · Granbury, TXBuilt 2006 · S/N 91050N147DSDavis Brady · Acampo, CABuilt 1973 · S/N 439N147DTGabriella Elena Inc · Winnetka, ILBuilt 1998 · S/N E-3163N147EBMalott David · Glade Park, COBuilt 1975 · S/N 20-1165N147ECAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1963 · S/N 27-2399N147ETLynch Francis X · Dumont, NJBuilt 1962 · S/N CD-571N147FWParr William R Jr · Mason, TXS/N 80771N147GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881111N147GGZeng Robert E · Owasso, OKBuilt 1962 · S/N TC-260N147GTFlying W Aviation LLC · Bossier City, LABuilt 2004 · S/N 1069N147HAPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10219N147HBCooley Timothy · Gilbert, AZBuilt 2017 · S/N 18283011N147JFour Seven Jays Flying Club Inc · Rapids City, ILBuilt 1973 · S/N 17262545N147JKKuehn John · Sammamish, WABuilt 1999 · S/N 2257N147JSScrobola James M · Wyoming, PABuilt 2019 · S/N SCROBOLA 0001N147KLarson David W · New Iberia, LABuilt 1975 · S/N 18264068N147LD1944 Holding Inc Trustee · Wilmington, DEBuilt 2004 · S/N 0937
Back to AD 2007-04-19 R1