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.

N6269VGopher One LLC · Willernie, MNBuilt 1967 · S/N D-8598N626SKelly Kendall J · Mckinney, TXBuilt 1966 · S/N D-8052N6276VHilsenroth Robert · Fernandina Beach, FLBuilt 1967 · S/N D-8603N6277VBlue Jay Aviation · Lake Placid, FLS/N D-8601N6278VMontana Excursions LLC · Modesto, CABuilt 1968 · S/N D-8602N627AJJorfam Properties LLC · Dripping Springs, TXBuilt 1974 · S/N D-9583N627BWoods William E · Phoenix, AZBuilt 1961 · S/N D-6767N627DHottle Marlin DBA · Chambersburg, PAS/N D-2888N627Q4s Technologies Inc · Beaver Dams, NYBuilt 1958 · S/N D-5627N627TBobo Kenneth O · Auburndale, FLBuilt 1958 · S/N D-5747N6284VBradsher Harold Michael · Troy, MOBuilt 1967 · S/N D-8605N6287VGilbert Gavin J · Granbury, TXBuilt 1967 · S/N D-8607N628DMoler Alan D · Valley Center, KSBuilt 1951 · S/N D-2889N628TStaggs Steven C · Rockwall, TXBuilt 1958 · S/N D-5751N6296VFollis Chad · Hartford, IABuilt 1967 · S/N D-8621N6298VRegistered aircraftBuilt 1967 · S/N D-8611N629QSpeedyvee LLC · Nathrop, COBuilt 1959 · S/N D-6260N629TGarrard Nathan M · Winston, ORS/N D-5752N62BJCapital Dental Management Inc · Dover, DEBuilt 1973 · S/N D-9414N62BSBasmadjian Aram · Macungie, PABuilt 1962 · S/N D-6986N62EMHarris Jesse C IV · Laurel Park, NCBuilt 1966 · S/N D-8081N62GBBeavers Glenn A · Wichita Falls, TXBuilt 1967 · S/N D-8566N62TPHunsberger Greggory S · Plantation, FLS/N D-6586N630DHanson Aaron J · Williston, NDS/N D-2892N630SUWinchester Jerry L · Nichols Hills, OKS/N D-9022N6318STilbury Mitchell Allen · Blaine, MNBuilt 1975 · S/N D-9829N631DKyczak Aviation LLC · Midvale, UTBuilt 1951 · S/N D-2893N631TJohnson Charles Eric · Belden, MSBuilt 1958 · S/N D-5758N632BBickers Kevin · Tehachapi, CABuilt 1957 · S/N D-5367N632THogle LLC · Gilbert, AZBuilt 1958 · S/N D-5632N635APLambert Kurt P · Albuquerque, NMBuilt 1974 · S/N D-9674N635DBlue River Holdings LLC · Hugo, OKBuilt 1951 · S/N D-2957N635PPBodor Geza S · Denver, COBuilt 1967 · S/N D-8637N635TJones Donald R · Sandwich, ILBuilt 1958 · S/N D-5769N635VSun Up Farm LLC · Nacogdoches, TXBuilt 1966 · S/N D-8083N6361CMaples Lee Trustee · Belle, MOBuilt 1982 · S/N D-10384N636DJunipero Aviators LLC · Redondo Beach, CAS/N D2899N636QShaw Aviation LLC · Solomon, KSBuilt 1958 · S/N D-5711N636TRegistered aircraftBuilt 1958 · S/N D-5709N6370SFreeland Christopher G · Brownwood, TXS/N D-9832N637DFiske Scott H · Minnetrista, MNS/N D-2900N637QBravo Sierras LLC · Omaha, NEBuilt 1959 · S/N D-5906N6397SIts Allgood Air LLC · Lewes, DEBuilt 1975 · S/N D-9833N639QKim Sungtae · Fort Worth, TXBuilt 1959 · S/N D-5839N63DWHogg James R · New Albany, OHBuilt 1960 · S/N D-6589N63LFChase 13 LLC · Wilmington, DEBuilt 1958 · S/N D-5666N63PTSkypoint Aviation LLC · Wilmington, DES/N D-7135N64098Sottile Joseph Jr Trustee · Chandler, AZBuilt 1978 · S/N D-10128N6409SWas He Slow LLC · Chagrin Falls, OHBuilt 1976 · S/N D-9838N640DBridges Janiece R · Forsyth, MOBuilt 1951 · S/N D-2904
Back to AD 94-20-04 R2