OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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.

N55078Tiritilli Robert · Mission Viejo, CABuilt 1973 · S/N 28-7325320N5507LFletcher Alex J · Weston, WIBuilt 1974 · S/N AA5-0627N5507PMccleskey Nicholas J · Mcminnville, ORBuilt 1978 · S/N 1043-78N5507WBurnett Fred · Greenbrier, ARBuilt 1978 · S/N 365-78N55080Keath Brian S · Kansas City, MOBuilt 1973 · S/N 28-7305305N55087Fosso Christopher M · Glendale, AZBuilt 1973 · S/N 28-7305308N5508JPaetzold Larry E · Brownwood, TXBuilt 1978 · S/N 1048-78N5508LDe Lint Marcus W · Cove, ORBuilt 1978 · S/N 1049-78N5508QSchmidt James A · Richmond, VABuilt 1965 · S/N 707N5508WEkkel Bob J · Newaygo, MIBuilt 1962 · S/N 28-596N55094Remedy Aviation LLC · Langford, SDBuilt 1973 · S/N 28-7325322N55096Robinson Jeffrey M · Scottsboro, ALBuilt 1973 · S/N 28-7305311N5509FAhs Aero LLC · Leo, INS/N 28-24850N5509JJet Air Inc · Iowa City, IABuilt 1980 · S/N 17273810N5509QCarlson Jeremy Nathaniel · Arnold, CABuilt 1965 · S/N 2943N5509WKitts John L · New Braunfels, TXBuilt 1962 · S/N 28-597N550DEJanay Jesse A · Charlottesville, VABuilt 1998 · S/N 2656N550FLKennedy Adam B · Des Moines, WAS/N 28-7125387N550PEHeller Ross S · Gig Harbor, WAS/N 550N550PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842106N5510FHughes Arlen L · Saratoga, WYBuilt 1968 · S/N 28-24851N5510WMilius Douglas L · Oshkosh, WIBuilt 1962 · S/N 28-598N55115Gleason Ronald L · Willows, CAS/N 28-7305313N5511FSmith Jimmy A Jr · Albemarle, NCBuilt 1968 · S/N 28-24852N5511PGear Down Hangar LLC · Phoenix, AZBuilt 1958 · S/N 24-574N5511QJohnston Evan · Yakima, WABuilt 1965 · S/N 2944N55121Lifetime Adventures LLC · Bellevue, MIBuilt 1981 · S/N 17275114N55124Stroud Stephen D · Independence, MOS/N 28-7325329N55126Zing Aviation And Marine LLC · New Smyrna Beach, FLFirst renewal noticeBuilt 1981 · S/N 17275116N55127Lands James M · Stoutsville, OHBuilt 1973 · S/N 28-7305314N55129Bauer Roger · Saint Germain, WIBuilt 1973 · S/N 28-7305319N5512EMorcom Aviation Services Inc DBA · Everett, WABuilt 1978 · S/N 17271881N5512FWestergaard Wayne B · Craig, NEBuilt 1968 · S/N 28-24854N5512URegistration Pending · Smiths Station, ALRegistration pendingBuilt 1969 · S/N 28-26223N5512VCabaniss Tex P Jr · Cypress, TXBuilt 1977 · S/N 28-7725240N5512WMoy Jack M · Los Angeles, CABuilt 1962 · S/N 28-600N5512ZShadow Aviation Inc · Fairbanks, AKBuilt 1964 · S/N 18-7845N55135Air Ventures Flying School LLC · Smithfield, RIBuilt 1973 · S/N 28-7325331N55136Alberio Angela E · Bloomington, MNBuilt 1973 · S/N 28-7325332N55139Hanson Mark A · Snelling, CABuilt 1973 · S/N 28-7305320N5513UShi Yi · Walnut, CABuilt 1969 · S/N 28-26225N5513WJohnson Thomas D · Pilot Mountain, NCBuilt 1962 · S/N 28-601N55140Di Giorgio Thomas J Jr · Lopez Island, WABuilt 1973 · S/N 28-7305321N55144Bell Air LLC · Las Cruces, NMBuilt 1981 · S/N 17275118N55146Sky High Aviation LLC · Gonzales, LABuilt 1981 · S/N 17275119N55148Lierle Sidney D · Clearlake, CABuilt 1973 · S/N 28-7325333N55149County 17 Aviators LLC · Gillette, WYS/N 28-7325334N5514FWingrove Rodney W · Vincent, OHBuilt 1968 · S/N 28-24856N5514MPruitt Buster Jr · Shelbyville, TNBuilt 1967 · S/N 113N5514PCohran Enterprise LLC · Pineville, LABuilt 1958 · S/N 24-577
Back to AD 79-10-03 R2