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.

N6879CParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7816437N687KBBoekelheide Kim · East Greenwich, RIBuilt 2002 · S/N 5687N687SSSciscoe William D · Dish, TXS/N MB-675N6880BAllmaras Donald P · New Rockford, NDBuilt 1956 · S/N 18-5067N6880NLawrence John J · Cypress, TXBuilt 1968 · S/N 680127N6880PBryant Michael E · West Chester, PABuilt 1960 · S/N 24-2016N6880VCraft Steven W · Port Saint Lucie, FLBuilt 1975 · S/N 20-1167N6880WRegistered aircraftBuilt 1965 · S/N 28-21036N6880ZMayes Brett R · Williams, CAS/N 25-2605N6881NMorris Michael R · Columbus, OHBuilt 1968 · S/N 680155N6881UElliott James C · Parker, COBuilt 1963 · S/N 2585N6881VCox Colin T · Harbinger, NCS/N 20-1168N6881WLewis Mark A · Ozark, ALBuilt 1965 · S/N 28-21037N6882UHoecher Robert T · Anchorage, AKS/N 2586N6883BSlagle Allen E · Newcastle, WYBuilt 1956 · S/N 18-5070N6883JRobbins John L · Crossville, TNS/N 28-7615387N6883NAj Mooney LLC · Port Saint Lucie, FLBuilt 1968 · S/N 680128N6883ZFoster Gary L · Palmer, AKBuilt 1964 · S/N 18-8136N6884HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17265625N6884NLutes Kent A · Tazewell, TNBuilt 1968 · S/N 680157N6884USheaffer Bruce R Jr · Lititz, PABuilt 1963 · S/N 2588N6885HRasmussen Stewart · Santa Barbara, CABuilt 1975 · S/N 17265626N6885NPoskevich Douglas · Deland, FLBuilt 1968 · S/N 680158N6885UGranier Bernie C Trustee · Bandera, TXBuilt 1963 · S/N 2589N6885WMiller Andy D · Marana, AZS/N 28-21041N6886BOhmans Inc · Gillette, WYBuilt 1956 · S/N 18-5073N6886HParr Larry · Clarksville, TNBuilt 1975 · S/N 17265627N6886JFlanders David J · Madison, WIBuilt 1976 · S/N 28-7690421N6886NSibille Keith Curtis · Griffin, GABuilt 1968 · S/N 680129N6886UN6886u Inc · Tucson, AZBuilt 1963 · S/N 2590N6886WGregory Joshua L · Oxford, MSBuilt 1965 · S/N 28-21042N6887NColton Frank Lasusa · Harrisburg, PABuilt 1968 · S/N 680159N6887UAce Aircraft Leasing Inc · Nazareth, PABuilt 1963 · S/N 2591N6888BVenell Farms Inc · Corvallis, ORBuilt 1956 · S/N 18-5076N6888HN6888h LLC · Wayne, NJS/N 17265628N6888NGrass James Conrad · Phoenix, AZS/N 680160N6888WAnderson Ty M · Grenada, MSBuilt 1965 · S/N 28-21045N688CABetter Southlake Properties LLC · Pagosa Springs, COS/N 17262505N688HZumbrun Dennis L · Montz, LABuilt 1993 · S/N 2341N688TAircapital Nevada Inc · Carson City, NVBuilt 1958 · S/N TD-75N6890RBudgeon Mark K · Mandeville, LABuilt 1990 · S/N 195690N6890WRegistered aircraftS/N 28-21047N6891BSchachle Theodore A · Willow, AKS/N 18-5080N6891HRegistration Pending · Uvalde, TXRegistration pendingBuilt 1975 · S/N 17265630N6892JHunter Trevor C · N Ogden, UTBuilt 1976 · S/N 28-7615389N6892NStratte Joseph J V · Yakima, WABuilt 1968 · S/N 680131N6892WRussell Steven D · Waxhaw, NCBuilt 1965 · S/N 28-21049N6893EArmstrong Bruce · Port Orchard, WABuilt 1960 · S/N 56393N6893FAligence Air LLC · Spring Hill, FLBuilt 1976 · S/N 28-7715185N6893URk Management LLC · Garden City, KSBuilt 1963 · S/N 2597
Back to AD 79-10-03 R2