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.

N8414RVick Justin M · Morton Grove, ILBuilt 1966 · S/N 28-22291N8414WOhmacht Carlton J · Glenwood, MNBuilt 1965 · S/N 28-2638N8414YLone Oak Aviation LLC · Greenville, NCBuilt 1981 · S/N 28-8190279N84151Sanders George W · Cloverdale, INBuilt 1969 · S/N 17258358N84153Spirit Air Inc · Salmon, IDBuilt 1969 · S/N 17258360N8415RMahanna John A · Radcliff, KYBuilt 1966 · S/N 28-22348N8415YSchwend Brian · Forsyth, MTBuilt 1969 · S/N 18-8859N84162Crosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1969 · S/N 17258362N84169Roach Gene T · Frankfort, KYS/N 17258363N8416JEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1983 · S/N 0359N8416RExpert Staffing West Inc · Ramona, CABuilt 1966 · S/N 28-22293N8416WCass Aviation LLC · North Las Vegas, NVBuilt 1965 · S/N 28-2642N84170Follmer Todd F · Dunwoody, GABuilt 1969 · S/N 17258364N84176Brandywine Flight School · West Chester, PABuilt 1981 · S/N 28-8116275N8417CDolan Joseph B · Baltimore, MDBuilt 1976 · S/N 28-7625114N8417JAtkinson Joseph M · Phoenix, AZBuilt 1980 · S/N VAC-159-80N8417YHighhouse Alan J · Honesdale, PABuilt 1970 · S/N 18-8861N84183Chickadee Aviation LLC · Burr Ridge, ILBuilt 1969 · S/N 17258368N84185Harrison Gene R · Pendleton, ORS/N 17258348N84186Gould George Jr · Bryantville, MABuilt 1969 · S/N 17258369N8418CWingman Aircraft Repair Inc · Lawrenceville, GABuilt 1976 · S/N 28-7615106N8418JBrown Jerry D · Rio Rancho, NMS/N VAC-164-80N8418RCarlsson Carl J · Mason City, IABuilt 1966 · S/N 28-22295N8418WMadison Mike · Pittsburg, TXBuilt 1965 · S/N 28-2644N84190Frs & Craig Llp · Byron, GABuilt 1969 · S/N 17258371N84193Smirnov Alexei · Fair Lawn, NJBuilt 1969 · S/N 17258372N84194Ultra Aviation LLC · Cedar Bluff, VABuilt 1969 · S/N 17258373N84195Norcal Flight Center LLC · Lincoln, CABuilt 1969 · S/N 17258374N8419CMarsh Geoffrey E · Old Lyme, CTBuilt 1976 · S/N 28-7615107N8419HHoke William Jr · Charlestown, INBuilt 1981 · S/N 28-8190291N8419JHammonds Hangars Inc · Wilmington, DEBuilt 1980 · S/N VAC-168-80N8419RLytle Cole · North Palm Beach, FLS/N 28-22296N841BKKilpatrick Joseph C · Atlanta, GABuilt 1966 · S/N 28-3255N841CMTalley-Sickles Jacqueline M · Oxnard, CAFirst renewal noticeBuilt 1969 · S/N 28-5488N841EDR&D Aviation LLC · Fayetteville, GABuilt 1967 · S/N 28-4273N841JARicci Theodore J · Spotswood, NJBuilt 1968 · S/N 17256902N841JWScenic Concepts LLC · La Crosse, WIBuilt 1974 · S/N 17264340N841NHMarrs Matt · Bentonville, ARBuilt 2020 · S/N P07-16N/17N-P011N841PGeeslin James W Jr · Sterling, AKBuilt 1985 · S/N 96N8420CRegistered aircraftBuilt 1976 · S/N 28-7690138N8420DAlsworth Glen R Sr · Port Alsworth, AKBuilt 1958 · S/N 22-5675N8420JGimple Herman Wm · Greenville, CABuilt 1980 · S/N VAC-169-80N8420LHayhurst Shane R · Winfield, PABuilt 1968 · S/N 17256620N8420RMueller Lance · Milton, DEBuilt 1966 · S/N 28-22349N8420WMckee Shane D · Fairbanks, AKS/N 28-2647N8420YVanwarmerdam Leslie C · Nampa, IDS/N 18-8862N84210Pm Jets LLC · Ashland, OHBuilt 1969 · S/N 17258380N84214Planefully Obvious LLC · Oshkosh, WIBuilt 1969 · S/N 17258382N8421DPutman Bruce C · Leonard, MIBuilt 1957 · S/N 22-5676N8421JRegistered aircraftBuilt 1980 · S/N VAC-166-80
Back to AD 79-10-03 R2