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.

N28950Fischer Andrea D · Belleville, KSBuilt 1978 · S/N AA5B0903N28957Western States Holdings LLC · Sheridan, WYBuilt 1987 · S/N 1016N2895GWilkins Ranch Inc · Marsland, NEBuilt 1967 · S/N 175N2895PDawes Donald E · College Place, WABuilt 1955 · S/N 18-4493N2895QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259895N2895RCarlson Aaron J · La Villa, TXBuilt 1987 · S/N 1015N2895XBoydn2895x LLC · Santa Cruz, CABuilt 1967 · S/N 17700295N28969Silva Carlos A · Massapequa, NYBuilt 1978 · S/N AA5B0911N2896EFlight Club 502 Inc · Louisville, KYBuilt 1978 · S/N 17271365N2896QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17259896N28973Coffman Joseph Bryan · North Pole, AKBuilt 1987 · S/N 1018N28976Kirby Benjamin · Colorado Springs, COBuilt 1978 · S/N AA5B0914N2897MInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 28-7816323N2897UWwe LLC · Ridgway, COBuilt 1987 · S/N 1017N28981Walker William B · Spokane, WABuilt 1978 · S/N AA5B0919N28983Radel Anne-Marie · West Hills, CABuilt 1978 · S/N AA5B0921N28986Recreation Plus Inc · London, OHBuilt 1978 · S/N AA5B0922N2898TR P M Flying Club Inc · South Holland, ILS/N 28-7225275N2898XOzment Dennis W · Palmyra, MOS/N 17700298N289915 By 5 Aircraft LLC · New Braunfels, TXBuilt 1978 · S/N AA5B0926N28993Fradkin Tyler Jacob · Redondo Beach, CABuilt 1978 · S/N AA5B0927N28995Carlson Linda · Broomfield, COBuilt 1978 · S/N AA5B0929N28996H&A Aviation Lc · Hanover, VABuilt 1978 · S/N AA5B-0930N28998Clark Glenn W · Mary Esther, FLS/N AA5B0933N2899GYoungpeter David L · Spencerville, OHBuilt 1968 · S/N 177N2899TLessley Aviation LLC · Winona, MSBuilt 1972 · S/N 28-7225276N289BBPeters Alan M · Arcola, TXBuilt 1996 · S/N 193N289HFLiegl Benjamin A · Fort Worth, TXBuilt 1977 · S/N AA5B0686N289HPLemon And Black LLC · Raleigh, NCBuilt 2003 · S/N 2843544N289JKFlightpath Aviation Services Inc · Brooksville, FLBuilt 1976 · S/N 17267701N289PSWillkris Aviation Services LLC · Smithfield, VABuilt 1972 · S/N 370-72N289RBarrows Robert E · Fincastle, VAS/N 195602N289SRFedora Lisa L · Southampton, MABuilt 1973 · S/N 435-73N289WDDunn William M · Malibu, CAS/N 444N28AGZahler Mitchell J · Stillwater, MNBuilt 1946 · S/N 42N28CMFiorita Vincent L · Wooster, OHBuilt 2004 · S/N 485-2004N28CRKeating Lawrence A · Newark, DEBuilt 1989 · S/N 694RN28CSEmerald Aero LLC · Pace, FLS/N 3164N28DKBoudreau Robert D · Rusk, TXS/N 417N28DTSilverstreak Aviation LLC · The Villages, FLBuilt 2002 · S/N 2843534N28EWEdwards Jason L · Lone Rock, WIS/N 289-EW-2N28FACivil Air Patrol · Maxwell Afb, ALBuilt 1980 · S/N 17274208N28FFCaicedo David · Villa Rica, GABuilt 1962 · S/N 28-208N28GMForinger Mark A · Pinehurst, NCBuilt 1976 · S/N AA5A0272N28HCGingras John T · Bakersfield, CABuilt 1977 · S/N 399N28HGHill Donald G · Westerly, RIBuilt 1978 · S/N AA5B0868N28HUKahonees Air Service LLC · Bozeman, MTBuilt 1998 · S/N 1414N28JTThorpe J C · Creswell, ORBuilt 1992 · S/N 7207 G-574N28JYYau Jay J · Torrance, CABuilt 2011 · S/N 71333N28KCoss Clayton L · Muskogee, OKBuilt 1968 · S/N 1
Back to AD 79-10-03 R2