OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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:79-10-03-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:79-10-03-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.

N8138HAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1979 · S/N 28-8090178N8138WSky Air Inc · Cedar Rapids, IABuilt 1965 · S/N 28-2251N8138YBelmont Aviation LLC · Port Saint Lucie, FLBuilt 1979 · S/N 28-8090180N81391Gibney Frank A · Colchester, VTS/N 1102N81398Mast Henry V · Dayton, TXBuilt 1995 · S/N 22327N8139EElliott Carl J · Fort Worth, TXRegistration revokedBuilt 1959 · S/N 1410N8139NPerucca Douglas E · Wasilla, AKBuilt 1998 · S/N 3650N8139WHigh Five Flight Inc · Dawson, NEBuilt 1965 · S/N 28-2252N813BSutter Timothy C · Glennallen, AKS/N 6743N813BDD & D Airpark LLC · Anchorage, AKBuilt 2009 · S/N AF18183N813CTDoolley Flyers LLC · Harvard, MABuilt 1985 · S/N 28-8590080N813KMSantopietro Paul · Dunnellon, FLBuilt 2001 · S/N 1321-2001N813PBunn Dennis E · Wilson, NCBuilt 1979 · S/N 28-7990589N813SSLake In The Hills Aviation LLC · Algonquin, ILBuilt 1974 · S/N 28-7415543N813WKTinney Michael · Piedmont, ALBuilt 1972 · S/N AA5-0106N8140DMckellar John T · Hamburg, NYBuilt 1957 · S/N 22-5631N8141DCasper Glen · Garden City, KSS/N 22-5632N8141KKezele William A · Idaho Falls, IDBuilt 2022 · S/N 1083N8141WParham Randy L · Saint Charles, MOBuilt 1965 · S/N 28-2254N8141ZFbni Inc · Oakland, MDBuilt 1979 · S/N 28-8016240N8142Hostetler Craig L · Glendive, MTS/N FS-1N81425Pegasus Copters LLC · Makawao, HIBuilt 1945 · S/N 7AC-42N8142DMontague Mark W · Reno, NVBuilt 1957 · S/N 22-5633N8142EAbourezk Michael C · Rapid City, SDS/N 1413N8142HC & T Aviation Holdings Inc · Mckinney, TXBuilt 1982 · S/N 28-8216118N8142JGriffith Charles · Santa Maria, CABuilt 1995 · S/N 9595N8142KHesseltine Robert J · Grand Terrace, CABuilt 1982 · S/N 28-8216120N8142LWesellairplanes Com Inc · Wilmington, DEBuilt 1994 · S/N 2416N8142YGarner Charles E · Sitka, AKBuilt 1967 · S/N 18-8593N8143HHahn Jeffrey L · Whitewater, WIBuilt 1982 · S/N 28-8290096N8143P8143 Leasing LLC · Manassas, VABuilt 1963 · S/N 24-3396N8143WMartell Ryan · Madison Heights, VABuilt 1965 · S/N 28-2257N81441Thomas Ramone O · Philadelphia, PABuilt 1979 · S/N 28-8016241N8144CMusgrove Stacy J · Cunningham, TXBuilt 1954 · S/N 22-2289N8145DJindra Russell L · Glennallen, AKBuilt 1957 · S/N 22-5636N8145PRegistered aircraftBuilt 1963 · S/N 24-3398N8145VAscend Aviation LLC · Bountiful, UTS/N 28-8016244N8145WNagel Thomas H · Tiffin, OHBuilt 1965 · S/N 28-2259N81465Cornia Robert W · Long Beach, CAS/N 571N8146AQuinn James F · Canton, MAFirst renewal noticeBuilt 1979 · S/N 28-8090217N8146WKemp Terry L · Lowell, ARBuilt 1965 · S/N 28-2260N8147WFirst Landings Aviation LLC · Apopka, FLBuilt 1965 · S/N 28-2261N8147XKahn David I · Briarcliff Manor, NYBuilt 1979 · S/N 28-8090177N8148JAir Winner LLC · Warner Robins, GAS/N 28-8016248N8148LMeriden Aviation Center LLC · Meriden, CTBuilt 1979 · S/N 28-8016249N8148PYobs Robert E · Crozet, VABuilt 1979 · S/N 28-8016250N81493N81493 LLC · Racine, WIBuilt 1979 · S/N 28-8090226N81497Skyward Air Inc · Los Angeles, CAS/N 28-8090227N8149AKemp Roger W · Montgomery, ALBuilt 1980 · S/N 28-8090224N8149RRepublic Aviation Corp · Wilmington, DEFirst renewal noticeBuilt 1980 · S/N 28-8016254
Back to AD 79-10-03 R2