OpenAirDocs.org
AD 94-20-04 R2

Registered aircraft · 4,469

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

N5007BGunnarsson Jon · Concrete, WABuilt 1955 · S/N D-4267N5008Holmes John K · Spring, TXBuilt 1959 · S/N D-5865N5008BHolley Air LLC · Fayetteville, ARBuilt 1955 · S/N D-4268N5009BAcosta Mario L · Eagle Nest, NMBuilt 1955 · S/N D-4269N500KTLincoln Land Airmotive LLC · Springfield, ILBuilt 1958 · S/N D-5662N500PFHumphries Stephen A · Kingwood, TXBuilt 1964 · S/N D-7484N500WMBim-Merle Robert W III · Piqua, OHBuilt 1961 · S/N D-6691N5013BNorris Ken DBA · Sumner, TXBuilt 1955 · S/N D-4275N5014BMacpherson Sherman D · Colusa, CABuilt 1955 · S/N D-4276N5017BBarnes Roger A · Rogers, ARBuilt 1955 · S/N D-4281N5024BRoduner Leroy R · Benton, KSBuilt 1955 · S/N D-4289N5025BHayes David A · Steward, ILS/N D-5003N5027BWilliams Air Power Inc · Lowell, MIS/N D-4292N5028BAttorneys Flying Partnership L P · Knoxville, TNBuilt 1955 · S/N D-4294N5029BGorman Michael J · Shadow Hills, CABuilt 1955 · S/N D-4296N502MWWhite Mark S · Kilgore, TXBuilt 1958 · S/N D-5606N5031BBurkle Roberto E · Bullard, TXBuilt 1955 · S/N D-4298N5035BBohdan Lebid · Roscoe, ILS/N D-4312N5036BHassan Richard · Ogden Dunes, INBuilt 1955 · S/N D-4303N5037BBaum Benjamin · Magnolia, MNS/N D-4314N5038BWells Propane Inc · Wells, NVBuilt 1955 · S/N D-4321N5039BHaring Clay · Lincoln, KSBuilt 1955 · S/N D-4306N5040BFarley Steven D · Newalla, OKBuilt 1955 · S/N D-4307N5042BPowell Jerry R · Kokomo, INBuilt 1955 · S/N D-4309N5043BRegistered aircraftBuilt 1955 · S/N D-4310N5045BChi Yang · Lafayette, COFirst renewal noticeS/N D-4323N5047BHenderson Lester W · Lafayette, LABuilt 1955 · S/N D-4317N5049BQualitair LLC Trustee · MichelstadtBuilt 1955 · S/N D-4311N5050XGrevatt Douglas E · Norwalk, CTBuilt 1952 · S/N D-3150N5051BNiksadat Abbas · San Jose, CABuilt 1955 · S/N D-4313N5053BWalline Christopher · Mcpherson, KSS/N D-4332N5055BN5055 B Partners · Long Beach, CABuilt 1955 · S/N D-4331N5056BWelsh Kevin J · Roseburg, ORBuilt 1955 · S/N D-4352N5057BRuther Dennis A · Lake Havasu City, AZS/N D-4358N5059BMcleod Lee · Derby, KSBuilt 1955 · S/N D-4266N5060BBolin William E · Smithville, OHBuilt 1955 · S/N D-4329N5061BNettrour Jerry · Floresville, TXBuilt 1955 · S/N D-4265N5062BHarris Beth · Albuquerque, NMBuilt 1955 · S/N D-4351N5066BBond Family Limited Partnership · Oriental, NCS/N D-4386N5067BMerritt John H K · Avondale Estates, GABuilt 1955 · S/N D-4387N5068BZulu LLC · Hattiesburg, MSS/N D-4363N506HPPedden Patrick M · Fort Wayne, INBuilt 1969 · S/N D-9073N5070BRyan Paul · Brea, CABuilt 1955 · S/N D-4349N5072BCopeland Patrick N · Madisonville, TNFirst renewal noticeBuilt 1955 · S/N D-4359N5073BRisk Andrew David · Camarillo, CABuilt 1955 · S/N D-4370N5075BParker Josh T · Fort Worth, TXBuilt 1955 · S/N D-4372N5080BQualitair LLC Trustee · MichelstadtBuilt 1955 · S/N D-4374N5081BFisher Bruce C · Shoreline, WABuilt 1955 · S/N D-4364N5090BHighland Investments LLC · Wilmington, DES/N D-4384N5091BDale Richard C · La Vernia, TXS/N D-4381
Back to AD 94-20-04 R2