OpenAirDocs.org
AD 68-20-06

Registered aircraft · 864

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:68-20-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:68-20-06')
  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.

N10133Fisher Charles R Jr · San Antonio, TXBuilt 1948 · S/N NAV-4-1766N10145Hensarling Matthew L · Elizabeth, COBuilt 1948 · S/N 48-999N1046WGoodin Ross W Jr · Enterprise, MSS/N NAV-4-54N10552Jed Homes Inc · Lisbon, CTS/N NAV-4-1078N105ERSokoloski James J · Lampasas, TXBuilt 1947 · S/N NAV-4-521N1061YSeward Mark A · Seattle, WABuilt 1969 · S/N NAV-4-2531N1069Byrne Sofia V · Merrimack, NHBuilt 1948 · S/N NAV-4-1775N107SWanagel Walter · Lisbon, CTBuilt 1949 · S/N NAV-4-1946N10894Holcomb Daniel F · Galena, ILS/N NAV42333BN109DSBell Bradley L · Bothell, WABuilt 1948 · S/N NAV-4-1373N10JFRempert Erich A · Lake Geneva, WIS/N NAV-4-1391N10WDEgmond Aircraft LLC · Lewes, DEBuilt 1964 · S/N NAV-4-2494N1102VRaimondi Jennifer Le · Rancho Murieta, CAS/N NAV-4-2089N111KMJohnston Cheryle L · El Centro, CABuilt 1946 · S/N NAV-4-324N114ERempert Erich A · Lake Geneva, WIS/N NAV-4-16N118AANorthern Valley Air Ltd LLC · Long Island, KSS/N NAV-4-110N11FZHolguin Steven · Hayward, CABuilt 1946 · S/N NAV-4-263N1208UPulliam Anthony L · Lancaster, CABuilt 1949 · S/N 1803N120LDJ & G Aircraft LLC · Chandler, AZBuilt 1961 · S/N NAV-4-2355N124RMGolden Dreams LLC · Missoula, MTBuilt 1946 · S/N NAV-4-136N134WBMeaux Frederick · Port Neches, TXS/N NAV-4-2034N137MFHuston Lee E · Graham, WABuilt 1948 · S/N NAV-4-1605N14SXMiller Randy · Greer, SCBuilt 1946 · S/N NAV-4-416N15CPBedingfield John R · Piedmont, SDBuilt 1948 · S/N NAV-4-1243N1622TMcpherson Bruce A · Burien, WABuilt 1962 · S/N NAV-4-2468N17VYVallee Jean-Francois R · Everson, WAS/N NAV-4-461N182PGaines Robert M · Nashville, TNBuilt 1956 · S/N NAV-4-1246N188PABradley Max T II · West Plains, MOBuilt 1949 · S/N NAV-4-1979N191Lubecke Robert D · Oconomowoc, WIBuilt 1950 · S/N NAV-4-2033N1947UTri Pacer Air LLC · Pennington, NJBuilt 1946 · S/N NAV-4-394N1CSMoseley Ailsa · Wellington, FLBuilt 1946 · S/N NAV-4-106N1EWNelson Patrick A · Winston, GABuilt 1962 · S/N NAV-4-2480N1YPLovelace Patricia Executor · San Angelo, TXBuilt 1950 · S/N NAV-4-2154BN20000Madshack Naviation LLC · Reston, VABuilt 1958 · S/N NAV-4-1787N208WSMoore David P · Chugiak, AKBuilt 1969 · S/N NAV-4-2528N20SHCsw LLC · Anacoco, LAS/N 4-131N212LInternational Air Services Inc Trustee · Carson City, NVBuilt 1948 · S/N NAV-4-1159N21ZZMadshack Aviation LLC · Reston, VABuilt 1962 · S/N NAV-4-2405N222LWSlocum Jon M · Newaygo, MIBuilt 1949 · S/N NAV-4-1899N225ELetsom Steven D · Eugene, ORBuilt 1948 · S/N NAV-4-1160N225HJMao Darwin · Las Vegas, NVS/N NAV-4-188N22AWare Steven E Trustee · Lonoke, ARBuilt 1946 · S/N NAV-4-19N22VSchadler Alletta M · Fredericksburg, PABuilt 1949 · S/N NAV-4-866N2357TB & R Aviation LLC · Pine Knoll Shores, NCBuilt 1961 · S/N NAV-4-2357N2358TNewcom Bradly C · Hanson, KYBuilt 1961 · S/N NAV-4-2358N2360TAerojet Sevices Inc · Aurora, COBuilt 1961 · S/N NAV-4-2360N2363TKan-Do Inc · Danbury, CTBuilt 1961 · S/N NAV-4-2363N2365TTodd John R · Flower Mound, TXBuilt 1962 · S/N NAV-4-2365N2367THunsaker Matthew L · De Pere, WIBuilt 1961 · S/N NAV-4-2367N2369TRangemaster Adventures LLC · Union Hall, VABuilt 1965 · S/N 2369
Back to AD 68-20-06