Skip to content

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N2830QRetro Modern Aviation LLC · Manitou Springs, COBuilt 1971 · S/N 17259830 N2830TThree Zero Tango Corporation · Wentzville, MOBuilt 1972 · S/N 28-7205229 N2830XCollins Stanley T · Elizabethtown, KYBuilt 1967 · S/N 17700230 N28316Rmp LLC · Pocatello, IDS/N AA5B0558 N2831GJohnston Skippy W · Fairbanks, AKBuilt 1967 · S/N 57 N28320James Allan L · Eloy, AZBuilt 1977 · S/N AA5B0559 N28328Plein Lindsay E · Wrightwood, CABuilt 1977 · S/N AA5B0562 N2832MCronin Terrance F · Federal Way, WABuilt 1977 · S/N 28-7816316 N2832TKirtland Air Force Base Aero Club · Kirtland Afb, NMBuilt 1972 · S/N 28R-7235142 N28330Neumayer Barry A · Redlands, CABuilt 1977 · S/N AA5B0563 N28331Samoskevich Stephen A · Trumbull, CTBuilt 1977 · S/N AA5B0564 N28335Vance Marc G · Canal Winchester, OHS/N AA5B0567 N28336Kittenplan Alex H · Millbury, MABuilt 1977 · S/N AA5B0568 N28338Registered aircraftBuilt 1977 · S/N AA5B0569 N28339St Laurence Perry N · La Mesa, CABuilt 1977 · S/N AA5B0570 N2833DScott Glen H · Spring, TXBuilt 1979 · S/N 28-7916451 N2833FWeaver Arnold G · Sandusky, MIBuilt 1979 · S/N 28-7916452 N2833NLansing Community College · Mason, MIBuilt 1979 · S/N 28-7916453 N2833ZVaughn James F · La Porte, INS/N 22-6828 N28345Avivus LLC · Austin, TXBuilt 1977 · S/N AA5B0575 N28347Adriatic Holdings LLC · Cheyenne, WYBuilt 1977 · S/N AA5B0576 N2834BSager Arthur · Joseph, ORBuilt 1979 · S/N 28-7990477 N2834PStevens Constance I · Homewood, CABuilt 1955 · S/N 22-3127 N2834QHarford Flying Club Inc · Kingsville, MDBuilt 1971 · S/N 17259834 N2834XEtown Powersports · Elizabethtown, KYBuilt 1967 · S/N 17700234 N28350Tatsch Carl L · Ringoes, NJBuilt 1977 · S/N AA5B0579 N2835MWth Aviation Services LLC · Scott City, KSBuilt 1977 · S/N 28-7890271 N2835QSan Fernando Aviation LLC · Van Nuys, CABuilt 1971 · S/N 17259835 N28360Albert Lea Airport Inc · Albert Lea, MNBuilt 1979 · S/N 28-7916403 N28361Propell Air LLC · Deridder, LAS/N 28-7916404 N2836GRed Rock Fly LLC · Lewes, DEBuilt 1979 · S/N 28-7916459 N2836PWells Michael D · Wilton, MEBuilt 1955 · S/N 22-3133 N2836TRegistered aircraftBuilt 1972 · S/N 28-7225245 N2836XWheeler Kimberly · Kent, WABuilt 1967 · S/N 17700236 N28379Daly William C · Sunrise Beach, TXBuilt 1977 · S/N AA5B0580 N2837QChaffee Dean L · Weidman, MIBuilt 1971 · S/N 17259837 N2837THuffman Jacob M III · Burleson, TXBuilt 1972 · S/N 28-7225246 N2837XAirspeed Marketing LLC · Phoenix, AZBuilt 1967 · S/N 17700237 N28381Hanscom Aero Club · Hanscom Afb, MABuilt 1979 · S/N 28-7916408 N28382Sale Reported · Three Lakes, WISale reported, canceledBuilt 1977 · S/N AA5B0581 N28383Hoffman Stephen A · Hereford, TXBuilt 1977 · S/N AA5B0582 N28386Smith Brent C · Edgewood, NMBuilt 1977 · S/N AA5B0584 N28389Rykowski William · Chilmark, MABuilt 1977 · S/N AA5B0586 N2838DHis Promise Aviation Service Inc · Big Spring, TXBuilt 1979 · S/N 28-7916463 N2838FGordon Brennan L · Houston, TXBuilt 1979 · S/N 28-7916464 N2838QAdriatic Holdings LLC · Cheyenne, WYBuilt 1971 · S/N 17259838 N2838ZHanrahan Andrew D · Soldotna, AKBuilt 1959 · S/N 22-6833 N28390Sahu Varun Kumar · Union City, CABuilt 1977 · S/N AA5B0587 N2839BGartman Henry L Sr · Moberly, MOBuilt 1979 · S/N 28-7990485 N283CAVero Technical Support Inc · Pensacola, FLBuilt 1979 · S/N 44-7995225

Back to AD 79-10-03 R2