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.

N167LDRegistered aircraftS/N 670105N167MSMullinax Robert A · Toccoa, GABuilt 1993 · S/N 2105N167PCBlue Mountain Flyers Inc · Palmerton, PABuilt 2003 · S/N 1349-2003N167RMSellman Richard · Chadron, NEBuilt 1967 · S/N 18-8514N167TCFarzaneh-Far Ramin · Brookline, MABuilt 2001 · S/N 1304-2000N1680APaprocki Jason C · Fairplay, COS/N 20-842N1681PWarner Philip · San Marcos, CABuilt 1954 · S/N 22-2467N1682JBeatty Gary A · Mosinee, WIFirst renewal noticeBuilt 1967 · S/N 28-24083N1683JMiranda Emigdio · El Dorado Hills, CAS/N 28-24084N1684JJarriel Investments Inc · Register, GABuilt 1967 · S/N 28-24086N1685Lane Aviation LLC · Tijeras, NMBuilt 2008 · S/N 030-53/54-704N1685GBrisson Gisele A · Hollister, CABuilt 1968 · S/N 194N1685PMckinney Derrill L · Rio Linda, CABuilt 1954 · S/N 22-2471N1686ELiddick Terry S · Spearfish, SDBuilt 1978 · S/N 17271093N1686JPatterson John E · Jacksonville, ILBuilt 1967 · S/N 28-24088N1687GSimon Mitchell B · Edison, NJFirst renewal noticeS/N 196N1687JMarsh Flyers LLC · Britton, SDBuilt 1968 · S/N 28-24089N1687PSofia De Venecia LLC · Southampton, NYBuilt 1954 · S/N 22-2473N1688ERegistered aircraftFirst renewal noticeBuilt 1978 · S/N 17271095N1688JTalley Charles B · Ignacio, COS/N 28-24091N1688TCape May Aero LLC · Cape May, NJBuilt 1970 · S/N 28-7125005N1688VAvstem Incorporated · Mc Grath, AKBuilt 1974 · S/N 17263714N1689JHouff Christopher J · Mount Crawford, VABuilt 1968 · S/N 28-24092N1689TFun Flyers LLC · Rapid City, SDBuilt 1970 · S/N 28-7125006N168ABerry James N · Abilene, TXBuilt 2001 · S/N JC8N168ALWittman Matthew · New York, NYBuilt 2000 · S/N 60168N168DMarolf Duke · Seward, AKBuilt 1963 · S/N 18-8293N168DDIndian Beach Aviation LLC · Clayton, NCBuilt 2003 · S/N 23811N168DPJohnson Eldridge Jr · Chicago, ILBuilt 1967 · S/N 28-4402N168KWWalsh Home Improvement Co Inc · Berlin, MDBuilt 1972 · S/N 28-7305031N168RGray Jim E · Punta Gorda, FLBuilt 1986 · S/N 168N168XBook Paul A · Richvale, CAS/N JC7N1690PPritchett Michael L · Benton, ARS/N 22-2476N1690THutchison Harry L · Grandview, MOS/N 28-7125007N1691GPalmer Christopher John · Upper Lake, CABuilt 1968 · S/N 134N1691JBaldwin Rickey Albert · Clarksville, VAS/N 28-24094N1691MMesser Richard J · Olean, NYBuilt 2005 · S/N 25238N1691PTomporowski Robert C · Mahwah, NJS/N 22-2477N1692GSmith Theodore M · Van Buren, MES/N 135N1692JMalkowski Joseph S Trustee · Lake Saint Louis, MOBuilt 1967 · S/N 28-24096N1692PHoffmeyer Ronald P · Rapid City, SDFirst renewal noticeBuilt 1954 · S/N 22-2478N1692TDhawan Gautam · Madison, MSBuilt 1970 · S/N 28-7125009N1693TMoburg Kenneth · Basehor, KSS/N 28-7125010N1694EAerobiz LLC · Lewes, DEBuilt 1978 · S/N 17271097N1694JLeemans Scott J · Queen Creek, AZBuilt 1967 · S/N 28-24099N1695HVista Air Inc · Pacoima, CABuilt 1977 · S/N 28-7725155N1695JHudson John P III · Grapeland, TXS/N 28-24101N1696GRives James · Moore Haven, FLBuilt 1968 · S/N 197N1696JHardin John M · Terrell, TXS/N 28-24102N1696TAircraft 1821 LLC · North Charleston, SCS/N 28-7125013
Back to AD 79-10-03 R2