OpenAirDocs.org
AD 85-03-04 R2

Registered aircraft · 340

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:85-03-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-03-04-R2')
  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.

N1797JMcmillan Law Firm Apc · La Mesa, CABuilt 1976 · S/N 13027N1808JNeissel Mark D · Gig Harbor, WAS/N 13028N1825JAction Interests Inc · Southlake, TXBuilt 1976 · S/N 13015N1858JKoenig Darrell Lee · Sumter, SCS/N 13031N1866JAnderson Dale · West Jordan, UTBuilt 1976 · S/N 13032N1882JMoody Bible Institute Of Chicago · Spokane, WABuilt 1976 · S/N 13034N1907JDaedal Flight LLC · Lancaster, SCBuilt 1976 · S/N 14007N1920JDerrick James E · Godley, TXBuilt 1976 · S/N 14020N192DBTodd Tracy · Lancaster, SCBuilt 1976 · S/N 14021N1931JAerodyme Corp · South Burlington, VTBuilt 1976 · S/N 14031N1934JN1934j LLC · Highland Lakes, NJBuilt 1976 · S/N 14025N1937JBryant Joe Henry Jr · Meridian, MSBuilt 1976 · S/N 14037N1938JCsi Asset Management Inc · Naples, FLBuilt 1976 · S/N 14036N1977JPicornell Francisco J · Malabar, FLBuilt 1976 · S/N 14080N197RCCaride Jose · Spring Hill, FLBuilt 1974 · S/N 197N19LHHollings Matthew C · Crowley, TXBuilt 1976 · S/N 14100N200CEBrewer Erich J · Thompson, MOBuilt 1977 · S/N 14257N202RRNorton Edward A · Las Vegas, NVS/N 350N2270KCeyer Benno O · Downers Grove, ILBuilt 1976 · S/N 14182N2299BEximious Flying Club Inc · Ferndale, MIBuilt 1977 · S/N 14169N2299DCheri Lee Inc · Kulpmont, PABuilt 1977 · S/N 14230N241GSmith Albert K · Pentwater, MIBuilt 1978 · S/N 14394N24BBSj Aviation LLC · Oxford, MIBuilt 1974 · S/N 157N260BGLeonard Katherine A · Fresno, CABuilt 1977 · S/N 14238N26HBBk Outlaws Inc · Myrtle Beach, SCBuilt 1978 · S/N 14379N27007Otstot Todd M · Boise, IDBuilt 1976 · S/N 483N29859Dangelo Thomas M · Plymouth, MIBuilt 1976 · S/N 14038N31JTParker Ray · Claremont, NHS/N 14352N3219PShoot LLC · River Ridge, LAS/N 14243N324XFontenot Ira Dean · Collierville, TNBuilt 1975 · S/N 300N423ATWillcutt Air Tax LLC · Vicksburg, MIBuilt 1978 · S/N 14391N427G5 Star Farm Management Inc · Linden, CABuilt 1977 · S/N 14294N437JWMj Product Sale Inc · Cape Coral, FLS/N 14075N4532WAbernathy Aviation LLC · Morristown, TNBuilt 1976 · S/N 13041N4533WNoco Bluesky LLC · Loveland, COBuilt 1976 · S/N 13042N4536WAlger Michael · Umatilla, FLBuilt 1976 · S/N 13046N4539WWjordan & Co LLC · New Fairfield, CTBuilt 1976 · S/N 13049N4566WBoling Kyle C · Oak Hill, FLBuilt 1976 · S/N 13056N4570WGuffey Jerry D · Lebanon, TNS/N 13060N4571WBernard Scott Sr · Denham Springs, LAS/N 13061N4572WKelton Joel B · May, TXBuilt 1976 · S/N 13062N4575WN4575w LLC · Santa Fe Springs, CABuilt 1976 · S/N 13065N4578WAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 13068N4589WBort Productions Inc · Covina, CABuilt 1976 · S/N 13079N4591WRojas Franklyn N · Ocala, FLBuilt 1976 · S/N 13081N4597WPelupessy Richard A · Roanoke, TXBuilt 1976 · S/N 13087N4603WReichen Kenton Ryan · San Francisco, CAS/N 13093N4604WPlotkin Terry M · Colorado Springs, COS/N 13094N4605WCoyner Philip C · Belpre, OHBuilt 1976 · S/N 13095N4606WCornwell Stephen E · Beaumont, TXBuilt 1976 · S/N 13096
Back to AD 85-03-04 R2