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.

N3592KBeckler Benjamin C · Middle Granville, NYBuilt 1967 · S/N 28-23647N3592PDengler Steven G · Lopez Island, WABuilt 1955 · S/N 18-4550N3592QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1973 · S/N 17261692N3592RBurnt Ridge LLC · Kalispell, MTBuilt 1969 · S/N 28-5705N3592XBryant David Wayne · Ada, OKBuilt 1968 · S/N 680161N35937Glaser Don E DBA · Willow, AKFirst renewal noticeBuilt 1975 · S/N U20602812N3593FEakin Robert C · Franklin, PABuilt 1970 · S/N 17259400N3593QKettunen Alan C · Ashtabula, OHBuilt 1973 · S/N 17261693N3594QGribble Ted A · Paris, TXBuilt 1973 · S/N 17261694N3595PSchumacher Craig A · Fairbanks, AKBuilt 1955 · S/N 18-4553N3595ZJohnson Issac · Krugerville, TXBuilt 1960 · S/N 18-7388N3596KStall Breakers LLC · Sachse, TXBuilt 1967 · S/N 28-23648N3597EBlue Bird Aero Club Inc · Bonne Terre, MOBuilt 1978 · S/N 17271601N3597KQuinn Knives LLC · Julian, CABuilt 1967 · S/N 28-23649N3597PBickford Tierra L · Big Lake, AKBuilt 1955 · S/N 18-4555N3599HSitter Duane A · Hayward, CABuilt 1977 · S/N 20-1238N3599ZBell Mark W · Soldotna, AKS/N 18-7393N359ALTyson Aviation LLC · Sherrills Ford, NCBuilt 1973 · S/N 17262020N359HEiden Ryan J · Central, AKBuilt 2024 · S/N JA2102155N359MAZig Zag LLC · Madison, ALBuilt 2000 · S/N 2069N359RVVik Douglas L · Payson, AZBuilt 2001 · S/N 23960N359TCMartin Robert · Amory, MSBuilt 2011 · S/N 11412N35AKPiatt Christopher M · Wasilla, AKS/N 1001N35AMJoseph Thomas C · Raleigh, NCS/N 28-5490N35ATLoomis Matthew · Oshkosh, NEBuilt 1973 · S/N 28-7305530N35CKColeman Tyler R · Sierra Vista, AZBuilt 1993 · S/N 20165N35DTTeufel Armin U · Phelan, CAFirst renewal noticeBuilt 1998 · S/N 321N35FBEwins John H · Danville, CABuilt 1969 · S/N JMKB-1N35KKearns Jeff C · Carrier Mills, ILBuilt 1995 · S/N 20482N35KCBuchanan Tevah · St George, UTBuilt 1996 · S/N 3-608N35LBWebb John M · Chugiak, AKBuilt 1973 · S/N 1N35PHTsi Holdco Inc · Virginia Beach, VABuilt 1984 · S/N 1981-AN35RSSudderth Robert W · Holly Lake Ranch, TXBuilt 1994 · S/N 1785LN35TXBauries Brian W · Abilene, TXBuilt 1994 · S/N 19020CN35WCHawley Flying Club Inc · Fargo, NDBuilt 1979 · S/N 28-8016180N35ZFlood Joseph W · Franklinville, NJBuilt 1987 · S/N 0Z-7N36008Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 268-73N3600PPaul Mike · Sprague, WABuilt 1955 · S/N 22-3321N3600RArapahoe Flight Club LLC · Colorado Springs, COBuilt 1969 · S/N 28-5706N3600ZDay Charles W · Sedan, KSS/N 22-7488N36010Eskildsen Chris A · Connell, WAS/N 535-73N36011Titus Larry E · Springview, NEBuilt 1973 · S/N 536-73N3601ELsn Air LLC · Morrison, COBuilt 1978 · S/N 17271603N3601PCox Jay D · Perryton, TXBuilt 1955 · S/N 22-3323N3601XHarrell Joshua Thomas · Forsyth, GABuilt 1968 · S/N 298N3601ZMid Atlantic Air Museum · Reading, PABuilt 1960 · S/N 22-7489N36028Armstrong Robert Reno · Lakin, KSS/N 264-73N3602KHoulton International Flying Club · Houlton, MEBuilt 1967 · S/N 28-23651N36031Markey William C Trustee · Wenatchee, WABuilt 1973 · S/N 540-73N3604HDobbelaere Bros Inc · Oakwood, OHS/N 20-1241
Back to AD 79-10-03 R2