OpenAirDocs.org
AD 94-05-05 R1

Registered aircraft · 26,232

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.

N78199Pearce Evan W · West Lafayette, INBuilt 1946 · S/N 2199N7819ELinscott Jeffrey R · Boring, ORBuilt 1959 · S/N 17619N7819ULott Tyler · Kenneth City, FLBuilt 1976 · S/N 15077849N781DDJp Aero Holdings Inc · Carson City, NVS/N 7EC-553N78204Gillaspie Wade D Jr · Huntsville, TXBuilt 1946 · S/N 2204N78209Walker Ray A · Sanger, TXBuilt 1946 · S/N 2209N7820UMorris Aviation LLC · Spring Hill, TNBuilt 1964 · S/N 17251820N7820XMassiel Galvan Grijalva Frida Trustee · Tucson, AZBuilt 1961 · S/N 17248320N7820ZBuckley Joseph L · Gulfport, MSBuilt 1963 · S/N 15059920N78217Gibsons Gas Inc · Holland, NYS/N 2217N78218Holliday Mark E · Lake Elmo, MNBuilt 1946 · S/N 2218N7821EOrvin Sanden Inc · Wyndmere, NDBuilt 1959 · S/N 17621N7821FKoch Leasing LLC · Campbellsville, KYBuilt 1966 · S/N 15063921N7821TCameron Michael Shelley · Reno, NVBuilt 1960 · S/N 47421N78223Jackson Johnny E · Jackson, GABuilt 1946 · S/N 2223N78225Holliday Mark E · Lake Elmo, MNBuilt 1946 · S/N 2225N7822UKelly John K · Summerfield, NCS/N 17251822N78230Hathy Albert J · Helena, MTBuilt 1946 · S/N 2230N78231Moriarty Joseph B Jr · Madbury, NHBuilt 1949 · S/N 2231N7823FJackson Larry T · Maplesville, ALS/N 15063923N7823ZFrost Read Ferguson · Burlington, VTBuilt 1963 · S/N 15059923N78244Schick Joleen G · Phoenix, AZBuilt 1947 · S/N 2244N78247Schmillen Gregg A · Phoenix, AZBuilt 1946 · S/N 2247N78248Ferguson Cris · Yuba City, CABuilt 1946 · S/N 2248N7824XClampitt Kenton V · Eckert, COBuilt 1960 · S/N 17248324N78251Barnett Paul S · Brookhaven, MSBuilt 1946 · S/N 2251N78256Ohnstad Kevin J · Argusville, NDBuilt 1946 · S/N 2256N7825UVan Dyke Randall R · Spencer, IABuilt 1964 · S/N 17251825N78261Walker Richard E · Quanah, TXBuilt 1946 · S/N 2261N78267Fenton Harry L · Rockton, ILBuilt 1946 · S/N 2267N7826UDenton Aeroworx LLC · Tucson, AZBuilt 1964 · S/N 17251826N78270Jones Allan M · Miamisburg, OHBuilt 1946 · S/N 2270N78274Newman Brian A · Caldwell, IDBuilt 1946 · S/N 2274N78275Bartosh Larry M · Abbott, TXBuilt 1946 · S/N 2275N78276Registered aircraftBuilt 1946 · S/N 2276N78277Belcher Wesley Jay · Fawn Grove, PABuilt 1948 · S/N 2277N78279Ulmer Bryce D · Locust Grove, GABuilt 1946 · S/N 2279N7827EFellars Richard L · Phoenix, AZBuilt 1959 · S/N 17627N7827GFlying Falkor LLC · Bellevue, WAS/N 15074732N7827TToler Gary P · San Clemente, CAS/N 47427N7827UCook Loretta · Bel Air, MDBuilt 1964 · S/N 17251827N7827XBarrows Carl A · Lisle, NYBuilt 1961 · S/N 17248327N78280Stroud Richard M · New Market, ALBuilt 1946 · S/N 2280N78282Harrington Michael R · Locust Grove, GABuilt 1948 · S/N 2282N78288Simmons William E · Port Orchard, WABuilt 1948 · S/N 2288N7828FTaylor Andrew G · Lexington, KYBuilt 1966 · S/N 15063928N7828TBunde Konstantine E · Goldendale, WABuilt 1960 · S/N 47428N7828UDroz Chris G · Jamul, CAS/N 17251828N7828XAero Smart LLC · Preston, IDBuilt 1961 · S/N 17248328N78290Mclellon Richard Steven · Littleton, COBuilt 1948 · S/N 2290
Back to AD 94-05-05 R1