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.

N4435VMacdonald Glenn · Sugar Land, TXFirst renewal noticeBuilt 1979 · S/N D-10225N4440DTalhelm Timothy A · Flint, MIS/N D-4556N4442DHentges Anthony · Canby, MNS/N D-4534N4443DVillacrez Enrique · Miramar, FLBuilt 1956 · S/N D-4580N4444KSivyllis Costas · Port Orange, FLFirst renewal noticeBuilt 1964 · S/N D-7422N4448DTimko Jeffrey Michael · Long Beach, CABuilt 1956 · S/N D-4560N444AFContinental Aero Associates Inc · Grosse Pointe Park, MIBuilt 1974 · S/N D-9590N444BJLelouis Michael P · Sacramento, CABuilt 1962 · S/N D-7023N444DGSwanson Douglas A · Marana, AZS/N D-9882N444DKPiggott Russell T · Fresno, CABuilt 1979 · S/N D-10296N444DWTriple 4 Dw LLC · Davie, FLBuilt 1972 · S/N D-9416N444RUFitzgerald Paul · Grapevine, TXBuilt 1973 · S/N D-9441N444TCHalstead Land & Cattle Inc · Arnold, NEBuilt 1975 · S/N D-9783N444WRNuccio Jeffrey W Trustee · Signal Mountain, TNBuilt 1977 · S/N D-10012N444XSmart Visual Systems LLC · Georgetown, TXBuilt 1958 · S/N D-5716N4451DRobbins William T · Lake Havasu City, AZS/N D-4594N4452DM & G Aircraft LLC · Plano, TXBuilt 1956 · S/N D-4593N4452WHubbard Mark A · Wilmington, DEBuilt 1974 · S/N D-9611N4456D6 Delta Llp · Charlotte, NCBuilt 1956 · S/N D-4672N4457SRegistered aircraftBuilt 1975 · S/N D-9775N4458ARaimondi Johann I · Doral, FLBuilt 1970 · S/N D-9145N4458DCrum Ryan C · Lebanon, TNBuilt 1956 · S/N D-4621N4461DRittenhouse David C · Park Hill, OKS/N D-4596N4462DOptima Aviation LLC DBA · Lewisville, TXBuilt 1956 · S/N D-4673N4463DJones Eugene E · Saint Johns, MIBuilt 1956 · S/N D-4645N4466DPearce Aircraft Services Inc · Peyton, COBuilt 1956 · S/N D-4591N4466SRegistration Pending · West Monroe, LARegistration pendingS/N D-9779N4468DPowr Investments LLC · Rockford, ILBuilt 1956 · S/N D-4582N4468WBorth John D · Meade, KSBuilt 1974 · S/N D-9604N446RDwons Roland Joseph · Oro Valley, AZS/N D-8474N446TThatcher James W · La Canada Flt, CABuilt 1970 · S/N D-9164N4470SFreitag Don M · Manhattan Beach, CABuilt 1975 · S/N D-9778N4471DKeys Sharlynn L · Sunset, TXBuilt 1956 · S/N D-4589N4475DNew Jersey Aero Club LLC · Hammonton, NJBuilt 1956 · S/N D-4619N4477DNoble Mitchell S · Carleton, MIFirst renewal noticeS/N D-4627N4479SN4479s LLC · Nashville, TNBuilt 1975 · S/N D-9790N4484WRegistered aircraftBuilt 1974 · S/N D-9581N4485SDickerson Stephen Sr · Frisco, TXBuilt 1975 · S/N D-9785N4486SPopadich Nicholas · Monroe, MIBuilt 1975 · S/N D-9788N4486WReynolds Eric Eugene · Weatherford, TXBuilt 1969 · S/N D-9070N4488DCountry Air Service Inc · Hecla, SDS/N D-4607N4489DV35g LLC · Norman, OKBuilt 1956 · S/N D-4618N4489PTj 2 LLC · Jackson, MIBuilt 1961 · S/N D-6769N448JDavenport James A · San Antonio, TXBuilt 1966 · S/N D-8127N4490DMillenia Aero LLC · New Hampton, NHBuilt 1956 · S/N D-4624N4493SRudrud David O Trustee · Scottsdale, AZBuilt 1975 · S/N D-9792N4494WConlon James E Jr · Troy, NYBuilt 1974 · S/N D-9614N4496SHme Holdings Group LLC · Franklin, INBuilt 1975 · S/N D-9793N4499DIndseth Thomas J · Moorpark, CABuilt 1956 · S/N D-4724N449PDN449pd LLC · Reno, NVBuilt 1955 · S/N D-4141
Back to AD 94-20-04 R2