AD 94-05-05 R1

Registered aircraft · 26,231

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:94-05-05-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:94-05-05-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.

N3597VMcleod Patrick J · Overgaard, AZBuilt 1975 · S/N 15076557N3597ZWallis Jeffrey D · Greenfield Twp, PAS/N 18-7390N35986Garst Charles L · Watson, MOBuilt 1941 · S/N 4-1468N3598CN3598c LLC · Ellisville, MOBuilt 1955 · S/N 26642N3598JMclaughlin George F · Kennesaw, GABuilt 1965 · S/N 15061298N3598LBryan Aviation LLC · Peoria, AZBuilt 1965 · S/N 15062398N35999Kline Paul · Brooklyn, MIBuilt 1941 · S/N 4-1483N3599SRichner Dennis M · Andover, MNBuilt 1963 · S/N 17250799N3599VMakee Markus · Painesville, OHBuilt 1975 · S/N 15076558N35CDewey James M · Santa Paula, CABuilt 1948 · S/N 104N35DFRoot Monty E · Lehigh, KSBuilt 1975 · S/N 973N35KBLewis Charles A · Winterville, NCBuilt 2007 · S/N CC11-00034N35PCHutchison Gil F · Salem, ORS/N 1578N35RJEarles Kenneth D · Crowley, LABuilt 1966 · S/N 15062932N35SVImes Thomas E · Bixby, OKBuilt 2003 · S/N 508N35THDull Thomas C · Los Angeles, CABuilt 2012 · S/N TH-5N35XXGroot Azarja · Lakehills, TXBuilt 2005 · S/N JR003N3600SRussell Scott Marvin · Sanger, TXBuilt 1963 · S/N 17250800N3600VTourt Jeffrey S · Yorkville, ILBuilt 1948 · S/N 14868N3602HSale Reported · Jadwin, MOSale reportedS/N 4227N3603LBeardsley David A · Arlington, WABuilt 1967 · S/N 17253772N3603SBetter Fly Inc · Litchfield, ILBuilt 1963 · S/N 17250803N3603VOwen Bertha C · Port Saint Lucie, FLBuilt 1948 · S/N 14871N3604ECollier-Sanuki J Scott · Fairbanks, AKBuilt 1947 · S/N 11AC-1820N3604JSmtm Holdings Inc · Wilmington, DES/N 15064904N3604VLindsey Roy W · Quinlan, TXBuilt 1948 · S/N 14872N3605JBon Investment Holdings LLC · Zephyrhills, FLBuilt 1966 · S/N 15064905N3605LUnger Aviation LLC · Saint Clair, MIBuilt 1965 · S/N 17253774N3605NMilne Jeff J · Lake Geneva, WIBuilt 1947 · S/N 22852N3606JElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1966 · S/N 15064906N3606VAimrich Enterprises Inc · Wilmington, DEBuilt 1948 · S/N 14874N3607JSmith Zachary L · Piedmont, SCBuilt 1966 · S/N 15064907N3607VDel Vecchio Thomas L · Middlebury, INBuilt 1975 · S/N 15076560N3608JSwartzentruber Thomas L · Oakland, MDBuilt 1966 · S/N 15064908N3609SSchuerch Vincent M · Wasilla, AKBuilt 1963 · S/N 17250809N3609VSidney Aviation LLC · Sidney, NEBuilt 1948 · S/N 14877N360CCKoelbl Michael · Whitesboro, TXBuilt 2008 · S/N CC11-00067N3611JShannon James P · Vandergrift, PABuilt 1966 · S/N 15064911N3611LVick Garland L · Benton, ARBuilt 1965 · S/N 17253780N3611SCombs Charles M · Mesa, AZS/N 17250811N3612LClean Waste Solutions LLC · Indianapolis, INBuilt 1965 · S/N 17253781N3612THamill Theo W · Durango, COBuilt 1976 · S/N F-066N3612VBenjamin Scott T · Estherville, IABuilt 1948 · S/N 14880N3613JBatista Brasil Vagner · Orlando, FLBuilt 1966 · S/N 15064913N3613SMccomb Charles D · Cypress, TXBuilt 1963 · S/N 17250813N3613VMcwilliams Eric T · Medina, OHBuilt 1948 · S/N 14881N3614Yokosawa Kenneth Eino · Grand Blanc, MIBuilt 1971 · S/N 001N3614JSikveland Beau D · Circle, MTBuilt 1966 · S/N 15064914N3614LHarris Danny R · Winnsboro, TXBuilt 1965 · S/N 17253783N3615KDuke Jimmy · Isola, MSBuilt 2018 · S/N 22305
Back to AD 94-05-05 R1