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.

N3541EClear Skies Aviation LLC · Longs, SCBuilt 1978 · S/N 17271578 N3541KGauvin Daniel G · Newport, VTBuilt 1967 · S/N 28-23616 N3541PZang Peng · Mason, MIBuilt 1955 · S/N 22-3297 N35420Edwards David S · Colbert, WABuilt 1968 · S/N 17256759 N35421Gleason Franklin R · Darlington, SCFirst renewal noticeBuilt 1968 · S/N 17256760 N35422Hamilton Pamela P · Norman Park, GABuilt 1968 · S/N 17256761 N35423Curenton Rufus B · Elmore, ALBuilt 1968 · S/N 17256762 N35425Calloway Julius W III · Indianapolis, INBuilt 1968 · S/N 17256763 N3542KJames Anthony · Lexington, NCS/N 28-23617 N35434Chalk 2 Inc · Apple Valley, CABuilt 1968 · S/N 17256768 N35441Boe Shay Lynn · Mesa, COBuilt 1968 · S/N 17256771 N35446Adelman Hiram · Bass Harbor, MES/N 17256773 N35449Whitlow Ray T · Shelbyville, KYBuilt 1968 · S/N 17256774 N3544KKelso Ted M · Fort Worth, TXBuilt 1967 · S/N 28-23618 N3544PClark John W · New Philadelphia, OHBuilt 1955 · S/N 22-3300 N3544XKing Richard S · San Antonio, TXBuilt 1999 · S/N 2068 N35450Cole William A · San Francisco, CABuilt 1968 · S/N 17256775 N35454Norman Robert Alan · Zanesville, OHBuilt 1968 · S/N 17256778 N35456Wing Dock LLC · Miami, OKBuilt 1968 · S/N 17256779 N3545DHudson Guy G · Chickaloon, AKS/N 27088 N3545KMil2atp Inc · Pikeville, NCBuilt 1967 · S/N 28-23619 N35461Registered aircraftBuilt 1968 · S/N 17256781 N35467Brown Wilson J · Statesville, NCBuilt 1968 · S/N 17256785 N35469Oord Joshua · Moses Lake, WABuilt 1968 · S/N 17256786 N3546EDussinger Andrew M · Enola, PABuilt 1978 · S/N 17271582 N3546KPrellwitz Randy · Fairbury, NEBuilt 1967 · S/N 28-23621 N3546ZPerkins Todd M · Lake Alfred, FLBuilt 1960 · S/N 22-7455 N35470Lombardi Michael J · Bloomfield Hills, MIBuilt 1968 · S/N 17256787 N35474Massey Shawn A · Satanta, KSBuilt 1968 · S/N 17256789 N35477Schmidt Edward J Sr · North Brunswick, NJBuilt 1968 · S/N 17256790 N3547KAlexander Robert D · Ardmore, OKBuilt 1967 · S/N 28-23622 N3547MBernstein Matthew D · North Charleston, SCBuilt 1978 · S/N 28-7816354 N35486Metz Air LLC · Little Rock, ARS/N 17256796 N35488Collins Mason G · Gillette, WYS/N 17256797 N3548PHalley Dan R · Avery, TXBuilt 1955 · S/N 22-3304 N3548TAlsworth Glen R Jr · Port Alsworth, AKBuilt 1973 · S/N F-007 N354CWhite River Resort Inc · Lakeview, ARBuilt 2000 · S/N 2119 N354CMMandes George J · Homer, AKBuilt 2005 · S/N 2313 N354MAAir Shares LLC · Casper, WYBuilt 2003 · S/N 2843545 N35501Wallis Aircraft Inc · Clifford Township, PABuilt 1968 · S/N 17256802 N3550PYates Darren L · Collinsville, OKBuilt 1955 · S/N 22-3306 N3550ZMcmillian Dean R · Wasilla, AKBuilt 1960 · S/N 22-7461 N35514Flying Services Inc · Wilmington, DEBuilt 1968 · S/N 17256808 N35517Mulder Kathleen M · Palmyra, PABuilt 1968 · S/N 17256809 N35519Baranowski John · Pleasant Grove, UTBuilt 1968 · S/N 17256810 N3551QHeatley Thomas L Jr · Gleason, TNBuilt 1973 · S/N 17261670 N3551ZAlpine Cable & Construction Inc · Grand Junction, COBuilt 1960 · S/N 22-7462 N35528Curtin John J · Palos Heights, ILS/N 17256816 N3552EAngel Aviation Inc · Peoria, AZBuilt 1978 · S/N 17271584 N3552MArcher Enterprises Inc · Sac City, IABuilt 1978 · S/N 28-7890313

Back to AD 79-10-03 R2