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.

N37JJMamuzich Robert J Jr · Ocala, FLBuilt 1987 · S/N 1243N37JNWings As Eagles Mission Air Service Inc · Oshkosh, WIBuilt 1997 · S/N 5373N37LMMay Richard A · Fort Mill, SCBuilt 1971 · S/N 170N37MFMueller Martin S · Coeur D Alene, IDS/N FREEMAN S T #1N37NERotor Technologies Inc · Nashua, NHBuilt 1994 · S/N 2450N37PVan De Pol John M · Amherst, TXS/N 21564N37RHRegistered aircraftBuilt 1995 · S/N 22585N37RNCicero John · Concord, CABuilt 2014 · S/N 90207N37SLRw Aviation LLC · Manitowish Waters, WIBuilt 1999 · S/N 2010N37WDRudy Schmitt · Brookshire, TXBuilt 1967 · S/N 28-4550N37WTFaulk County Flying Club Inc · Faulkton, SDBuilt 1978 · S/N 17271385N37WYWyo Ventures LLC · Buffalo, WYBuilt 2001 · S/N 2169N38000Gardner David J · Elk, WAS/N M-2297N3801PKnutson Wayne R · Thompson, NDBuilt 1955 · S/N 22-3490N3802RN3802r LLC · New Ringgold, PABuilt 1970 · S/N 28-5830N3802ZRowland Keith E · Glennallen, AKBuilt 1960 · S/N 18-7535N3803ESorbi Aviation Inc · El Cajon, CABuilt 1981 · S/N ME-381N3803ZDeines Gerald G · Red Lodge, MTBuilt 1960 · S/N 18-7536N3804KWebster Max S · Dalton, PABuilt 1967 · S/N 28-23736N3804PMadsen Theodore W · Gillette, WYBuilt 1955 · S/N 22-3493N3804QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17259904N3804ZCulbertson William Theodore · Helena, MTBuilt 1960 · S/N 18-7537N3805PSpinner Family Lp · White City, ORBuilt 1955 · S/N 22-3494N3806ZNamtvedt Erik · Wasilla, AKS/N 18-7539N3807PLuebber Jan D · Malaga, WAS/N 22-3496N3808MWings Of Clearfield Inc · Centre Hall, PABuilt 1978 · S/N 28-7816377N3808RCatalano Joan E · Sequim, WABuilt 1970 · S/N 28-5834N3809MWood Robert A V · Anchorage, AKBuilt 1947 · S/N 12-2731N380BPMoe Michael J · Detroit Lakes, MNBuilt 1996 · S/N 1N380CCHolmstrom Eric C · Las Vegas, NVBuilt 2001 · S/N 9934CCN380KCitabria Corporation · Wilmington, DEBuilt 2011 · S/N 543-2011N380MFRegistered aircraftBuilt 2003 · S/N 0038N380RADarnell Charles Bert · Glen Allan, MSBuilt 2005 · S/N 1380-2005N380RBShea Michael P · Nashua, NHBuilt 1987 · S/N 380N380UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 4496211N381Deal Mark A · Spartanburg, SCBuilt 1978 · S/N 3072N3810MSurgical Innovations Inc · Suwanee, GABuilt 1978 · S/N 28-7816378N3811KHendrickson Raymond G · Severn, MDBuilt 1967 · S/N 28-23737N38120Hudson Wilburn Joel · Rocky Face, GABuilt 1977 · S/N 28-7790520N3812CChristiansen Aviation LLC · Wilmington, DES/N ME-390N38146Olson Richard H Trustee · Walla Walla, WAS/N 28-7790241N38147St Denis Robert G · Lake City, FLBuilt 1977 · S/N 28-7725251N3814PJasinski Jack J · Necedah, WIS/N 22-3504N3814RCarlton Kevin · Mount Vernon, WABuilt 1970 · S/N 28-5835N3814VCert Works LLC · Bennett, COBuilt 1977 · S/N R1722264N3816PJohnson Dale M · Seminole, TXBuilt 1955 · S/N 22-3506N3816QGoli Aviation LLC · Raleigh, NCBuilt 1971 · S/N 17259916N3816ZBouchard Timothy D · Valdez, AKBuilt 1961 · S/N 18-7554N38177Archer Enterprises Corp · Ossining, NYBuilt 1977 · S/N 28-7790526N38178Gcs Aero LLC · Laramie, WYBuilt 1977 · S/N 28-7790527
Back to AD 79-10-03 R2