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.

N7182WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLBuilt 1963 · S/N 28-991N7183DFedorko Michael III · Spearfish, SDS/N 18-5647N7183QFlying Wild LLC · Yarmouth, MEBuilt 1972 · S/N 17260483N7183RNorton Charles · Coon Valley, WIS/N 28-21895N7184BBaldwin C R · Kenai, AKBuilt 1956 · S/N 18-5224N7184DWinters Jack F Jr · Fairbanks, AKBuilt 1957 · S/N 18-5649N7184LJames Danny F · Granbury, TXBuilt 1973 · S/N AA5-0484N7185BKistler Mark A · Wasilla, AKBuilt 1956 · S/N 18-5226N7185FBrw Aircraft Inc · Matawan, NJBuilt 1976 · S/N 28-7790186N7185GJones Mark R · Denton, MDS/N 17258885N7185RThain Paul K · Davenport, FLBuilt 1966 · S/N 28-21897N7185WHerriman Alan · Durham, NCBuilt 1963 · S/N 28-996N7186BSims William E · Anchorage, AKBuilt 1956 · S/N 18-5229N7186DHollingsworth Lloyd D · Anchorage, AKBuilt 1957 · S/N 18-5651N7186JBenavides Roberto O Jr DBA · Falfurrias, TXBuilt 2001 · S/N 3221N7186LHows Grandma LLC · South Daytona, FLBuilt 1973 · S/N AA5-0486N7186RRays Aircraft Sales LLC · Tolland, CTBuilt 2000 · S/N 3061N7187QChestnut Ridge Flying Club · Latrobe, PABuilt 1972 · S/N 17260487N7187WNew York Art Upholstery LLC · New York, NYBuilt 1989 · S/N 0955MN7187ZFlight Tech LLC · Prosser, WAS/N 18-8299N7188GVrechek Joseph D · Fort Lauderdale, FLS/N 17258888N7188LLopez Geo U · Round Rock, TXBuilt 1973 · S/N AA5-0488N7188PBackcourse Flyers Inc · Powell, TNS/N 24-2358N7188QToles Chad · Austin, TXFirst renewal noticeBuilt 1972 · S/N 17260488N7188WEchoaviation Holdings LLC · Akron, OHBuilt 1963 · S/N 28-999N7189GSky Hawk Flying Club · Grand Rapids, MNBuilt 1969 · S/N 17258889N7189KEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2000 · S/N 3118N7189LNotov Aleksandr · Broomfield, COBuilt 1973 · S/N AA5-0489N7189QMontgomery Paul · Fredericksburg, VABuilt 1972 · S/N 17260489N7189RPlymale Winston Leigh Jr · Salem, VABuilt 1966 · S/N 28-21902N718FLTubesing Gordon E · Palm Coast, FLBuilt 1972 · S/N 28-7225383N718HRMiller Glenn E · Albany, ORBuilt 1967 · S/N 18-8500N718TETheis Timothy J · St Charles, ILS/N 334-76N718WWilson Gregory A · Mc Alpin, FLBuilt 2010 · S/N 71754N7190BKing Tyler Brooks · Saint Stephen, SCBuilt 1956 · S/N 22-4385N7190CJets To Helis LLC DBA · Chandler, AZBuilt 2002 · S/N 3364N7190DWard Ben N · Salcha, AKBuilt 1957 · S/N 18-5657N7190GM T Machinery Inc · Porter, TXBuilt 1969 · S/N 17258890N7190LYoung Anthony G · Murray, KYBuilt 1973 · S/N AA5-0490N7190RChristopher Ralph K · Weedsport, NYS/N 28-21903N7190WAndros Aviation LLC · Santa Margarita, CABuilt 1963 · S/N 28-1002N7191DDahlen Bear A · Eugene, ORBuilt 1957 · S/N 18-5658N7191EStandard Aviation Services LLC · Farfurrias, TXBuilt 2000 · S/N 3120N7191PRamineni Raja · Fort Mill, SCBuilt 1961 · S/N 24-2361N71921Rychlik Kevin Charles · Manassas, VAS/N 3437N7192LCheek Donald · Ocala, FLBuilt 1973 · S/N AA5-0492N7192QMansfield Heliflight Inc · Milton, VTBuilt 1972 · S/N 17260492N7192SUniversal Technical Institute Inc · Phoenix, AZBuilt 2000 · S/N 3058N7192WPope Larry · Lake View, NYBuilt 1963 · S/N 28-1004N7193DKeech Paul A · Fairbanks, AKBuilt 1957 · S/N 18-5661
Back to AD 79-10-03 R2