AD 94-05-05 R1

Registered aircraft · 26,230

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-05-05-R1')
    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-05-05-R1')
  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.

N8778UWright Penny L · San Francisco, CAS/N 15077986N8779BMeyers Jess H · Las Vegas, NVBuilt 1957 · S/N 36479N8779GEga Aero Specialty Services LLC · Beaufort, SCBuilt 1966 · S/N 15062879N877ATAir One Inc · Valparaiso, INBuilt 1966 · S/N 15063724N877PCWilson James R Sr · Allen, TXBuilt 2006 · S/N AL-1029N877TFMattingly Bruce A · Morehead, KYBuilt 1965 · S/N 17252674N8780BHite Douglas T · Frisco, TXBuilt 1957 · S/N 36480N8780DN8780d LLC · Santa Cruz, CAS/N 18-6308N8780UReeves Gary A · Lorimor, IABuilt 1976 · S/N 15077988N8781UHalsey Gene L · Huron, SDBuilt 1965 · S/N 17252685N87822Cunningham Chris D · Juneau, AKS/N 15200N87825E C Nelson Inc · Rio Oso, CABuilt 1945 · S/N 15220N8783BRosine Steven D · Troutville, VAS/N 36483N8784UWilson Jacob T · Loma Linda, CABuilt 1976 · S/N 15077991N8785CStewart Robert J Jr · Erie, PABuilt 1953 · S/N 18-2881N8785GPate Robert J · Hilltop Lakes, TXBuilt 1966 · S/N 15062885N8785USchoenling Joseph S · Cincinnati, OHBuilt 1976 · S/N 15077992N8786GKellum Roman Micah · Alexander City, ALS/N 15062886N8786SJae Grace Elizabeth · Madison, ALBuilt 1966 · S/N 15062086N8786USchlosser Bryan Andrew · Sudlersville, MDBuilt 1965 · S/N 17252691N8787BHedgers Thomas W · Lino Lakes, MNS/N 36487N8787DRoss Scott · Middletown, NYS/N 18-6324N8787UMoody Bible Institute Of Chicago · Spokane, WAS/N 17252692N87881Wheeler Chris D · Moyie Springs, IDBuilt 1940 · S/N 15499N87884Wikle Arthur M · Glennallen, AKBuilt 1992 · S/N 92-00100N87888Janvrin Jerry M · Buffalo, SDBuilt 1946 · S/N 15506N8788GWagenaar Diane D · Frankston, TXBuilt 1966 · S/N 15062888N8789ULangley Bryan T · Springfield, OHBuilt 1976 · S/N 15077993N87905Neckels William H · Midvale, IDBuilt 1946 · S/N 15523N8790UPonte Ralph M DBA · Grass Valley, CABuilt 1976 · S/N 15077994N879132oh0 Cub LLC · Delaware, OHBuilt 1946 · S/N 15531N8791BCook Robert G · Rensselaer, NYBuilt 1957 · S/N 36491N8792UBenair LLC · Bonita Springs, FLBuilt 1976 · S/N 15077996N87947Meaders Alexis L · Hernando, MSBuilt 1946 · S/N 15565N8794SUS Flight Academy International Inc DBA · Post, TXBuilt 1965 · S/N 15062094N8794UMock Joseph R · Huntsville, TXBuilt 1976 · S/N 15077997N87951Sliger Van O · Cookeville, TNBuilt 1946 · S/N 15569N87954Holliday Richard A · Fort Worth, TXBuilt 1946 · S/N 15572N87956Miech Kenneth E · Casper, WYBuilt 1946 · S/N 15574N8795BE2 Technologies Inc · Grand Haven, MIBuilt 1957 · S/N 36495N8795DKowalski Ronald W · Mount Airy, NCBuilt 1958 · S/N 18-6338N8795GDesousa Raphael · Fremont, CABuilt 1966 · S/N 15062895N8795SHuffman Jacob M III · Burleson, TXBuilt 1965 · S/N 15062095N8796BTetrault Phil H · Chisago City, MNS/N 36496N8796GSouthwest Texas Junior College · Uvalde, TXBuilt 1966 · S/N 15062896N8796SSkylane Of Willmar LLC · Willmar, MNBuilt 1965 · S/N 15062096N8797GTriplett Joseph C II · Pontotoc, MSBuilt 1966 · S/N 15062897N8797USowers Harry D · S Bloomingville, OHBuilt 1976 · S/N 15077999N8798HNavion Customs LLC · Chino, CABuilt 1947 · S/N NAV-4-798N8798UMimbach Mitchell J · Rice, MNBuilt 1976 · S/N 15078000
Back to AD 94-05-05 R1