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.

N6060DHughes Truman C · Delta Junction, AKBuilt 1956 · S/N 22-4713N6060WNilsen Daniel P · Holmes, NYS/N 28-20072N6062ANelson Stephen H · Apple Valley, MNS/N 18-8009046N6062LFoo Flyers LLC · Charlotte, NCBuilt 1972 · S/N AA5-0162N6063ELawrence Aviation LLC · Overland Park, KSS/N 17271987N6063HHagerstown Flying Club · Williamsburg, INBuilt 1977 · S/N 28-7890203N6064DAcadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1956 · S/N 22-4717N6064QWilliams Rodney K · Stacy, MNBuilt 1965 · S/N 3249N6065HNoble Mark · Memphis, TNBuilt 1977 · S/N 28-7890204N6065QShick Douglas Todd · Chester, VAS/N 3250N6065WBeyond Aviation LLC · Jacksonville, FLBuilt 1964 · S/N 28-20077N6066DDaily John F · Chugiak, AKBuilt 1957 · S/N 22-4719N6066NPacific Union College · Angwin, CABuilt 1968 · S/N MB-398N6066WAshpaugh Larry D · Hilltop Lakes, TXBuilt 1964 · S/N 28-20078N6067NGustavson Allan R Jr · Tonopah, AZBuilt 1968 · S/N MB-391N6068DThorn Blake A · Coupeville, WAS/N 22-4721N6068NVan Steenburgh Owen Christopher · Manitowoc, WIBuilt 1968 · S/N MB-392N6068PGear Down Hangar LLC · Phoenix, AZBuilt 1959 · S/N 24-1164N6068WRivera Jose · Spencer, WVFirst renewal noticeS/N 28-20080N606BHWhite Montie Eugene Trustee · Hartsville, TNBuilt 2000 · S/N 002BHN606EAOakmere Leasing LLC · Norton Shores, MIBuilt 1979 · S/N 28-7916477N606ERHansen Justin L · St George, UTS/N MB-397N606HSMyers Kenneth K · Rangely, COBuilt 2003 · S/N 118N606RFFitts Robert D · Independence, ORBuilt 2025 · S/N 1N606TTTotusek Torger · La Palma, CABuilt 1985 · S/N 274N606WLarson Bernard J · Mt Vernon, WABuilt 1965 · S/N 3172N6070NKnott Donnie W · Milan, TNBuilt 1968 · S/N M-1164N6070QOdenbach Eric J · Eureka, SDBuilt 1966 · S/N 3328N6070WHocking Christopher J · Hinckley, MNBuilt 1964 · S/N 28-20082N6071DRiffle Thane G · Addy, WABuilt 1956 · S/N 22-4725N6071WAbbott Joseph D · Chippewa Falls, WIBuilt 1964 · S/N 28-20083N6072NDilecce Joseph · Sarasota, FLBuilt 1969 · S/N M-1209N6072WHillman Maritime Services LLC · Lafayette, LABuilt 1964 · S/N 28-20085N60733Rentner Judith E · Bigfork, MTS/N 18-3366N6073DDetrick Louis F · Eighty Four, PABuilt 1956 · S/N 22-4727N6073NRozinka Jay C · River Falls, WIBuilt 1968 · S/N M-1166N6073PBradshaw James L · Lenoir, NCBuilt 1959 · S/N 24-1169N6074NParlog Roy H · Irwin, PABuilt 1968 · S/N M-1167N6074PBerlingen Michael W · Oregon City, ORBuilt 1959 · S/N 24-1170N6074QMiranda Edward G · Prescott Valley, AZBuilt 1965 · S/N 3253N6074WRegistration Pending · Los Angeles, CARegistration pendingBuilt 1964 · S/N 28-20087N6075PMoore Leslie D · Raymore, MOBuilt 1959 · S/N 24-1171N6075VLister Cameron M · Loxley, ALBuilt 1958 · S/N 62057N6075WVolk Alyssa M · Jordan, MNBuilt 1964 · S/N 28-20088N6076DPinnow Andrew W · Cheshire, CTBuilt 1956 · S/N 22-4730N6076GColbert Farms Inc · Davenport, WAS/N 15071576N6076WBlyseth Brent A · Germantown, TNS/N 28-20089N6077DPargman Curtis A · Big Lake, MNBuilt 1957 · S/N 22-4731N6077NKrig Marie · Seattle, WABuilt 1969 · S/N M-1202N6077WParrish Stephen W · Minneola, FLBuilt 1964 · S/N 28-20090
Back to AD 79-10-03 R2