OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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.

N3630NSalvesen William · Clermont, NJBuilt 1967 · S/N 680018N3630RLachance John A · Thompson, CTBuilt 1971 · S/N 28-7125375N3631EMudcat Construction Inc · Beattyville, KYBuilt 1978 · S/N 17271611N3631PRoss Donald M · Fallbrook, CABuilt 1956 · S/N 22-3726N3631XLee Brent · Cumming, GABuilt 1969 · S/N 359N3632EHigh Exposure Inc · Wilmington, DEFirst renewal noticeBuilt 1978 · S/N 17271612N36335Simmons Darren · Diamondhead, MSBuilt 1973 · S/N 271-73N3633NPerotti Camille C · Carolina Beach, NCBuilt 1967 · S/N 680019N3633RGrammar Adrian Gates · Geneva, NYBuilt 1970 · S/N 28-5728N3634RRatkovich Stephen · Prospect Heights, ILBuilt 1971 · S/N 28-7125140N36350Hennager Eric D · Langdon, NDBuilt 1973 · S/N 272-73N36351Mueller Michael A · Seguin, TXBuilt 1973 · S/N 567-73N36355Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1978 · S/N 28-7816630N36358Hans Aviation Inc · Davie, FLBuilt 1978 · S/N 28-7816631N3635QFantini Real Estate LLC · Louisville, KYBuilt 1967 · S/N MB-246N3635XInternational Air Charter Inc · Intl Falls, MNS/N 5084N3635ZRiggi Dean A · Scotia, NYBuilt 1960 · S/N 22-7530N3636KCronin John M · Bremerton, WABuilt 1967 · S/N 28-23662N3637PBlazek Troy L · Cottage Grove, MNBuilt 1955 · S/N 22-3374N3637RGelinger Gary · Cape Carteret, NCBuilt 1970 · S/N 28-5732N3637ZFord Kristy M · Marianna, FLBuilt 1960 · S/N 22-7532N3638HQuantie Harold G · Locust Grove, OKS/N 20-1256N3638PSorrell Byron D · Warren, MIBuilt 1955 · S/N 22-3389N3638QWinder Keven S · Castle Rock, COBuilt 1967 · S/N MB-251N3638RDukeman James C · Apex, NCBuilt 1970 · S/N 28-5735N36393Meriden Aviation Center LLC · Meriden, CTS/N 28-7816633N36395Brittle Aviation LLC · Chapel Hill, NCBuilt 1978 · S/N 28-7816634N3639HBeatty Earl IV · Gambrills, MDBuilt 1978 · S/N 20-1257N3639PJoseph Patrick S · Saint Charles, MOBuilt 1955 · S/N 22-3390N3639ZStahl Calvin D · Auburn, WABuilt 1960 · S/N 22-7534N363GCPorter David R · Dayton, OHBuilt 1993 · S/N 363N363RVRoberts David · Albuquerque, NMBuilt 2010 · S/N 60388N36400Vlietstra Steven J · Hatley, WIBuilt 1978 · S/N 28-7890511N36409Wire Wonder Inc · New York, NYNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 28-7816636N3640NShaikh Samir K · Schaumburg, ILS/N 680021N3640QBenville Pete E Jr · Boonville, CABuilt 1967 · S/N MB-253N3640XDoerhoff Daniel L Trustee · Lone Jack, MOBuilt 1969 · S/N 348N3640ZElliott Frank F · Mojave, CABuilt 1960 · S/N 22-7535N36411Runsick Michael C · Wynne, ARBuilt 1973 · S/N 273-73N36417Huber Weylin L · Aberdeen, SDBuilt 1973 · S/N 575-73N3641NVilliger Arnold H · Henry, ILBuilt 1967 · S/N 680022N3641RGeorge Walker Field Inc · Bedminster, NJBuilt 1969 · S/N 28-5737N36424Fmy Inc · Honolulu, HIBuilt 1978 · S/N 28-7890514N3642MCraig James P · Jacksonville, ARBuilt 1947 · S/N 12-2497N3642PSkyranch Knoxville Youth Inc · Knoxville, TNBuilt 1955 · S/N 22-3393N3642QPorte Elvis · Miami, FLS/N MB-262N36434Phillips Aaron W · Fort Scott, KSBuilt 1973 · S/N 275-73N36438Dorman Richard E · Mesa, WABuilt 1973 · S/N 577-73N3643MKing Jay M · King Salmon, AKS/N 12-2496N3643NHoward Trae · San Antonio, TXBuilt 1967 · S/N 680023
Back to AD 79-10-03 R2