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.

N2005DT&H LLC · Cottage Grove, ORBuilt 1952 · S/N D-3355N2006DGraham Richard W · Rohnert Park, CABuilt 1952 · S/N D-3356N2007DHayes Donald · Mcloud, OKS/N D-3357N2008DDrevalas George · Bandon, ORBuilt 1952 · S/N D-3358N2008WSiamese Cat LLC · Issaquah, WABuilt 1965 · S/N D-7977N200BWGas Aviation LLC · Decatur, TNBuilt 1965 · S/N D-7954N2011DGardner Robert J · Reno, NVBuilt 1952 · S/N D-3361N2012WIron Compass LLC · Highland Park, MIBuilt 1965 · S/N D-7971N2015DAv8rs LLC · Portland, ORBuilt 1952 · S/N D-3366N2015VMangi Nitin · Hayward, CABuilt 1959 · S/N D-5760N2015WKrosswind Aviation LLC · Cape Coral, FLBuilt 1965 · S/N D-7975N2016DRbc Aero · Mooresville, NCBuilt 1966 · S/N D-8209N2016Y2016y LLC · Aurora, COBuilt 1978 · S/N D-10157N2017DCream Puff Classics Inc · Hubertus, WIBuilt 1952 · S/N D-3368N2017PBruninga Harold J · Jacksonville, ILBuilt 1978 · S/N D-10156N2018CChandelle Ltd · Brighton, COBuilt 1960 · S/N D-6498N2018DFluno John I · San Anselmo, CABuilt 1953 · S/N D-3423N201BSiemens Jonathan Lee · Seminole, TXBuilt 1956 · S/N D-4504N201JHSpero Alan J · Ramona, CABuilt 1966 · S/N D-8113N2020DPearson Martha A · Walnut Grove, CABuilt 1952 · S/N D-3371N2020WMidland Mist Inc · Midland, GABuilt 1966 · S/N D-8077N2021DDockter Travis R · Linton, NDS/N D-3372N2021EEagle Home Medical Corp · Roanoke Rapids, NCBuilt 1978 · S/N D-10158N20224Obie Aviation LLC · Rogers, ARBuilt 1978 · S/N D-10159N2022WStadelmann Joseph P · Milton, MABuilt 1965 · S/N D-7968N2024GPerry Scott D · Hood River, ORBuilt 1978 · S/N D-10162N2024KB2s Aviation LLC · Billings, MTBuilt 1978 · S/N D-10164N2024VWhiskey Tango Flyers Inc · Middletown, DEBuilt 1978 · S/N D-10165N2024WMunn Jeffrey R · Auburn, NYBuilt 1966 · S/N D-8078N2026DToro Miguel Angel · San Ysidro, CABuilt 1952 · S/N D-3377N2028AWallender Timothy J · Manhattan Beach, CABuilt 1969 · S/N D-9026N2028PFerm Michael D · Fort Calhoun, NEBuilt 1978 · S/N D-10167N2029DVictory Auto Sales LLC · Memphis, TNBuilt 1978 · S/N D-10168N202BCTff Inc · Parma, MIBuilt 1957 · S/N D-5199N202JRiche Aviation LLC · Baton Rouge, LABuilt 1964 · S/N D-7418N20307N20307 LLC · Trabuco Canyon, CABuilt 1978 · S/N D-10174N20318Siegfried Thelma Trustee · Downers Grove, ILBuilt 1978 · S/N D-10173N2032DCochran Douglas B · La Jolla, CAS/N D-3383N2032EOhio Air Partners LLC · Chardon, OHBuilt 1978 · S/N D-10170N2034DMcpartland Patrick R · Herriman, UTBuilt 1952 · S/N D-3385N2035DKnoxville Airventure LLC · Knoxville, TNBuilt 1952 · S/N D-3386N2035PHubert John P · Austin, TXBuilt 1978 · S/N D-10176N2037WGregs Crop Care Co · Wilbur, WABuilt 1965 · S/N D-7980N2038UWorld Aero Space Ltd · Henderson, NCBuilt 1978 · S/N D-10180N203PLHhj & Rbj Holdings LLC · Prattville, ALBuilt 1976 · S/N D-9898N203RTKinzer Richard J · Piney Flats, TNBuilt 1962 · S/N D-6931N2040ASchultz Philip W · Lancaster, CABuilt 1969 · S/N D-9024N2040PTrb Aviation LLC · Fredericksburg, VABuilt 1978 · S/N D-10183N2040YCappel Eric H · Satellite Beach, FLBuilt 1978 · S/N D-10181N2041DLyman Eric J · Upland, CABuilt 1952 · S/N D-3393
Back to AD 94-20-04 R2