OpenAirDocs.org
AD 94-18-04 R1

Registered aircraft · 1,310

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-18-04-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-18-04-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.

N6596QAsk42 Ltd · Stary DebiecBuilt 1966 · S/N A-96N6598QMcdonnell David · Belle Plaine, KSBuilt 1966 · S/N A-98N65GMSalmonson Stefan Virgil · Mora, MNBuilt 1965 · S/N A-53N65KPoland Linda J · Tawas City, MIBuilt 1946 · S/N 2493N666EAStevens Burton G · Las Vegas, NVBuilt 1946 · S/N 1258N66KSchaetzl Richard · Albuquerque, NMBuilt 1946 · S/N 1790N66YYFreeman Stephen K · Kingsbury, TXS/N 1643N676AAMcdonald Donald C Trustee · Owatonna, MNS/N 3069N67MReno Bill · Casa Grande, AZBuilt 1946 · S/N 339N7029UBohlke LLC · Kingshill, VIBuilt 1946 · S/N 3404N703VVBowers Airplanes LLC · Chesterfield, VABuilt 1946 · S/N 3230N71HMcdowell Donald L · Geneva, OHBuilt 1946 · S/N 1092N71VMcguire William P · Gobles, MIBuilt 1947 · S/N 4599N72DSGregory Vernon L · Swansea, SCBuilt 1946 · S/N 1012N72EToronidis Joannis · Ronkonkoma, NYBuilt 1946 · S/N 2918N72PPEd Stapleton Lawyer Pllc · Brownsville, TXS/N 2051N73PMSmith David James · Fort Mcdowell, AZBuilt 1970 · S/N 700018N744WHHampton Warren D · Sparks, NVS/N 3923N747ECGregory Vernon L · Swansea, SCBuilt 1946 · S/N 747N7500CBancroft Diane F · Hernando, FLBuilt 1957 · S/N 5612N7504CSmith Douglas B · Channahon, ILBuilt 1957 · S/N 5614N7508CPhilip Sims · Otis, COS/N 5618N7513CThomas Ronald L · Green Cove Springs, FLBuilt 1957 · S/N 5623N7515CPrater Jon Aaron · Palm Coast, FLBuilt 1957 · S/N 5626N7516CLubben Justin K · Dayton, VAS/N 5627N7519CCooke Riley O · Bridger, MTBuilt 1958 · S/N 5634N7520CKimball Hyland F · Columbus, NMBuilt 1958 · S/N 5635N7521CKorn Kenneth A · Tallahassee, FLBuilt 1958 · S/N 5636N7526CTrottier Trevor · Hyde Park, VTBuilt 1958 · S/N 5641N7531CGregory Vernon L · Swansea, SCBuilt 1958 · S/N 5646N7535CBerkbiegler L Allen · Lonedell, MOBuilt 1958 · S/N 5650N7536CCarroll Trent M · Corpus Christi, TXBuilt 1958 · S/N 5651N7537CChmiel John E · Rhinelander, WIBuilt 1958 · S/N 5652N7539CRandles Colt L E · Fayetteville, NCBuilt 1958 · S/N 5654N7541CBryan Paul D · Prineville, ORBuilt 1958 · S/N 5656N7542CSinclair Leonard A · Gypsum, COBuilt 1958 · S/N 5657N7543CArnold Charles W · San Diego, CABuilt 1958 · S/N 5658N7548CVandervoort Karen K · Waller, TXBuilt 1958 · S/N 5663N7549CMarsden Heath H · Newport, NHBuilt 1958 · S/N 5664N7550CRoman Steven T · Burgettstown, PAS/N 5667N7551CStradley Roger I · Belgrade, MTS/N 5668N7552CLancaster Clinton E Jr · Pikeville, NCS/N 5669N7553CMccall Richard Alan · Lexington, NCBuilt 1958 · S/N 5670N7556CHowe Robert T · Forked River, NJFirst renewal noticeBuilt 1959 · S/N 5673N7557CSims Michael R · Clancy, MTBuilt 1959 · S/N 5674N7559CProplastic Designs Inc DBA · Charlotte, NCBuilt 1959 · S/N 5676N7562CGraziano Thomas K · Benson, AZBuilt 1959 · S/N 5679N7563CQuandt Richard L · South Sioux City, NES/N 5680N7566CAnton Paul M · Salome, AZBuilt 1959 · S/N 5683N7567CVorpe Thomas · Pearland, TXBuilt 1959 · S/N 5684
Back to AD 94-18-04 R1