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.

N7163NMullaly Sean M · Haslett, MIBuilt 1968 · S/N D-8689N7164NFrancis Jesse R · Fort Worth, TXBuilt 1968 · S/N D-8691N7165NRegistered aircraftBuilt 1968 · S/N D-8692N7170NDemio Douglas · Westbrook, CTBuilt 1968 · S/N D-8696N7172NCourtney Mccutchen Insurance Agency Inc · Mertzon, TXBuilt 1968 · S/N D-8697N7173NVajdos Robert C Jr · Louise, TXBuilt 1968 · S/N D-8698N7177NStutz Jeffrey R · Redondo Beach, CABuilt 1968 · S/N D-8702N7185NNovac Consulting Group LLC · Scottsdale, AZBuilt 1968 · S/N D-8705N7193NGeier Michael J · Newport, RIS/N D-8704N7194NGazda Jerry V · Granbury, TXFirst renewal noticeBuilt 1968 · S/N D-8711N7195NNaylor James M · Clinton, NCBuilt 1968 · S/N D-8712N7196NWilliams Johnny Dewayne · Colbert, OKBuilt 1968 · S/N D-8706N719SGMaisel Chad L · Plano, TXS/N D-8714N71BKSelect Aerospace Industries Inc · Weyers Cave, VABuilt 1955 · S/N D-4401N71DLRegistration Pending · Poughkeepsie, NYRegistration pendingS/N D-7027N71HZYoung David K · Anna, TXBuilt 1964 · S/N D-7714N71YLN825fg Corp Trustee · Wilmington, DES/N D-9468N7201NWilliams Evan H · Sebastopol, CABuilt 1968 · S/N D-8815N7202BRegistration Pending · Peyton, CORegistration pendingBuilt 1958 · S/N D-5501N7202NBowers Enterprises LLC · Peachtree City, GABuilt 1968 · S/N D-8710N7203BBradley Albert B · Vacaville, CAS/N D-5507N7203NGrey Hairs LLC · Lake Saint Louis, MOBuilt 1968 · S/N D-8716N7205BBodo Martin J · Los Altos Hills, CABuilt 1958 · S/N D-5503N7208RBelford Mark C · Sammamish, WABuilt 1974 · S/N D-9699N720DApplied Professional Solutions Llp · Jacksonville, FLBuilt 1951 · S/N D-2991N720TMinter Michael D Jr · Rock Port, MOBuilt 1975 · S/N D-9813N7212BRegistration Pending · Boise, IDRegistration pendingS/N D-5522N7214BCoffman Robert P · Bigfork, MTBuilt 1958 · S/N D-5574N7215BCressler Keith R · Hoxie, KSBuilt 1958 · S/N D-5534N7216BSudweeks Will · Overton, TXBuilt 1958 · S/N D-5633N7217BChavoustie Graham · Alexandria Bay, NYBuilt 1958 · S/N D-5546N72191Nantz William G Jr · Raleigh, NCBuilt 1955 · S/N D-4229N7219BDel Tex Flyers Inc · Olton, TXBuilt 1958 · S/N D-5558N721RSStill Charles · Fountain Valley, CABuilt 1966 · S/N D-8086N721WTop Flight Aviation LLC · Kingfisher, OKBuilt 1972 · S/N D-9361N7221BWood Douglas R · Renfrew, PABuilt 1958 · S/N D-5527N7222BSkans David K · Henderson, NVBuilt 1958 · S/N D-5544N7226BDelone Charles · Sarasota, FLS/N D-5549N7227BYoung Donald Stuart · Markham, VABuilt 1958 · S/N D-5660N7229BManihuari Carlos A Ramos · Pittsburgh, PABuilt 1958 · S/N D-5542N722DRawls Steve · Fernandina Beach, FLBuilt 1951 · S/N D-2993N722SPSky Aviation Inc · Sheridan, WYS/N D-6926N7231BDendulk Arthur G Trustee · Hughson, CABuilt 1958 · S/N D-5540N7232B7232b LLC · Grosse Ile, MIBuilt 1958 · S/N D-5562N7233BMason Phillip Ray · Jacksonville Beach, FLS/N D-5554N7235BPresley Tony L · Deridder, LAS/N D-5553N7236BLakey Robert E · Arlington, TXBuilt 1958 · S/N D-5564N7241BBingham John Christopher · Lake Lotawana, MOBuilt 1958 · S/N D-5597N7244BRech Jack R · Diamond Bar, CABuilt 1958 · S/N D-5612N7248BSweeney James A · Ocala, FLBuilt 1958 · S/N D-5584
Back to AD 94-20-04 R2