Skip to content

Registered aircraft · 40,471

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N74099Sigg David · Bluffton, SCBuilt 1975 · S/N AA5B-0135 N7409DBartlett Donald R · Weirsdale, FLBuilt 1957 · S/N 22-5170 N7409GAero Quest LLC D/B/A · Olive Branch, MSBuilt 1970 · S/N 17259109 N7409JAdp Consultants Inc · Laurel, MDBuilt 1968 · S/N 28-24774 N7409PPeters Gordon J · Salem, ORBuilt 1961 · S/N 24-2596 N740HSSnook Harold F · Beaver Springs, PABuilt 1977 · S/N 18-7709067 N740UOhio University · Albany, OHBuilt 2005 · S/N 2842225 N74100Derby Kent E · Denver, COBuilt 1975 · S/N AA5B-0136 N74101Mickelsen Brian C · South Jordan, UTBuilt 1975 · S/N AA5B-0137 N74104Supan J T Trustee · Santa Cruz, CABuilt 1975 · S/N AA5B-0139 N74105Lamphier Marc S · Lawrence, MABuilt 1975 · S/N AA5B-0140 N74109Piscitello Thomas J · Yulee, FLBuilt 1975 · S/N AA5B-0145 N7410DHampton Michael D · Marshfield, MOFirst renewal noticeBuilt 1957 · S/N 22-5171 N7410JGeorge Ladelle · Ashley, NDBuilt 1968 · S/N 28-24775 N7410RElon Aviation LLC · Burlington, NCBuilt 1966 · S/N 28-21927 N7410WKlassen Peter K · Seminole, TXBuilt 1965 · S/N 28-2897 N7411DMclain Joseph L · Louisville, KYBuilt 1957 · S/N 22-5172 N74127Richards Michael W · Lafayette, INBuilt 1975 · S/N AA5B-0147 N7412JDubois Aviation Inc · Chino, CABuilt 1968 · S/N 28-24778 N7412RZembinski Robert A · Brookfield, WIBuilt 1966 · S/N 28-21929 N7412WRegistered aircraftRegistration pendingBuilt 1963 · S/N 28-1300 N7413DDraper Scott · Rutland, VTBuilt 1957 · S/N 22-5174 N7413JLittle Evin M · Bidwell, OHBuilt 1968 · S/N 28-24779 N7413RRegistration Pending · Gilbert, AZRegistration pendingS/N 28-21930 N7413WRivera Genaro · Clarksville, TNBuilt 1963 · S/N 28-1301 N74141Spragg Zachary · Great Mills, MDBuilt 1975 · S/N AA5B-0155 N74143Fearn Richard · Gainesville, GABuilt 1975 · S/N AA5B-0158 N74146Vick Brian · Lutz, FLBuilt 1975 · S/N AA5B-0159 N74147Shoppell Stuart J · Dahlgren, VABuilt 1975 · S/N AA5B-0160 N7414DCulver Robert D · Sacramento, CABuilt 1957 · S/N 22-5175 N7414RVx Aircraft Services LLC · Batesville, ARBuilt 1966 · S/N 28-21953 N74151Chapman Larry · Abilene, TXBuilt 1975 · S/N AA5B-0163 N7415KClarke Kenneth J · Anchorage, AKS/N 17259115 N7415RHolland Nathan A · Wildomar, CABuilt 1966 · S/N 28-21938 N7415VHall Kevin · Morgan, UTBuilt 1975 · S/N 20-1149 N7416CN7416c LLC · Anchorage, AKBuilt 2024 · S/N 347416 N7416GDreggors David Richard · Altamonte Springs, FLBuilt 1970 · S/N 17259116 N7416PDavenport Jimmy J · Hayesville, NCBuilt 1961 · S/N 24-2604 N7416RMessing Mathew · Bremerton, WABuilt 1966 · S/N 28-21940 N7416WEdmiston Jonathan B · Oak Harbor, WABuilt 1963 · S/N 28-1304 N7417DUnderwood Todd M · Foley, ALBuilt 1957 · S/N 22-5178 N7417PWhitewater Aviation Inc · Harrison, OHBuilt 1961 · S/N 24-2605 N7417RDestination Flyer LLC · Memphis, TNBuilt 1966 · S/N 28-21941 N7417VCottage Village Living II LLC · Brownfield, TXBuilt 1975 · S/N 20-1151 N7418RJones Clayton S · Boerne, TXS/N 28-21942 N7419GFlycarolina LLC · Concord, NCBuilt 1970 · S/N 17259119 N7419PBollfrass William Henry III · Rhinelander, WIBuilt 1961 · S/N 24-2607 N7419RDiorio Christopher J · Melba, IDBuilt 1966 · S/N 28-21944 N7419WBaker Terry · Mesa, AZBuilt 1977 · S/N M-1973 N741BDRitenour John E · Waynesboro, PABuilt 2002 · S/N 1024

Back to AD 80-04-03 R2