Skip to content

Registered aircraft · 25,370

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-25-07-R1') 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-25-07-R1') 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-25-07-R1')
    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-25-07-R1')
  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-25-07-R1')
  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-25-07-R1')
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.

N3354XVirginia Aircraft Rentals LLC · Broadway, VABuilt 1966 · S/N 1079 N3355EMiddletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1978 · S/N 17271515 N3356TCarlin Joseph A Jr · Rapid City, SDS/N 17700656 N3357THigh West Aero LLC · Broadus, MTBuilt 1967 · S/N 17700657 N3359TDuquette Robert R · Elfrida, AZS/N 17700659 N335BBVantrease David A · Wills Point, TXBuilt 1983 · S/N 24-1367 N335DSWhitaker Martin · Portland, MEBuilt 2008 · S/N 10702008 N335ERLandgraf Scott A · Buffalo, MNS/N 24-3162 N335RSYould Eric P Trustee · Palmer, AKBuilt 1977 · S/N 17268562 N3360XCrail Aviation LLC · Colorado Springs, COBuilt 1966 · S/N 3373 N3361TPew Aaron · Mesa, AZS/N 17700661 N3362TMain Cynthia M · Richmond, TXFirst renewal noticeBuilt 1967 · S/N 17700662 N3363EMcfly LLC · Casper, WYBuilt 1978 · S/N 17271518 N3363YCamlik Air LLC · Wausau, WIBuilt 1978 · S/N 21063145 N3364EPlsr LLC · Denton, TXBuilt 1978 · S/N 17271519 N3364THigh Mesa Aviation LLC · Naturita, COBuilt 1967 · S/N 17700664 N3364XDel Bene Dean A Trustee · Monee, ILBuilt 1966 · S/N 1085 N3368TTuley Richard L · Marietta, GARegistration revokedBuilt 1967 · S/N 17700668 N3368XI Have A Plane LLC · Lake Oswego, ORS/N 1087 N3369ERustmann Richard E · Willimantic, CTBuilt 1978 · S/N 17271520 N3369TBauer Charles · Graceville, MNS/N 17700669 N3369XCollins Jerod William · Conifer, COBuilt 1966 · S/N 1088 N336AFLaine Carey E · Nevada City, CABuilt 1972 · S/N 17260404 N336WTRomney Chad · Rigby, IDBuilt 2023 · S/N 1210-2023 N3371EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271521 N3371TSale Reported · Sanderson, TXSale reported, pending cancellationBuilt 1967 · S/N 17700671 N3372XLeahy David J · Delaware, OHBuilt 1966 · S/N 670028 N3374TLazy Eight LLC · Kalispell, MTS/N 17700674 N3374XLee Rollin Kim · Panaca, NVS/N 1091 N3376XVanmeter Investments LLC · Tecumseh, OKBuilt 1966 · S/N 3380 N3377XPenalo Garcia William J · Toa Baja, PRBuilt 1966 · S/N 1092 N3378CWaples Charles Andrew · Red Lodge, MTBuilt 1978 · S/N R18200277 N3378EVisalia Flyers LLC · Visalia, CABuilt 1978 · S/N 17271524 N3378XBurdis W J · Beaver Falls, PABuilt 1966 · S/N 1093 N337CACendejas Christian · Montclair, CABuilt 1979 · S/N 17272213 N337CBErickson Arnold F · Devils Tower, WYS/N 1337-80 N337GFLewis John P · Alachua, FLBuilt 1969 · S/N 17258349 N337MCLandavazo Joseph · Albuquerque, NMBuilt 1983 · S/N 24-1385 N337PCPhantom Technologies LLC · Garden City, IDBuilt 1980 · S/N 21064212 N3380XGretencord Howard F Trustee · Kansas City, MOBuilt 1966 · S/N 3381 N3381XBagwell Trevor T · Valencia, CABuilt 1966 · S/N 3382 N3383TBerkstresser John A · Ellijay, GABuilt 1967 · S/N 17700683 N3383XHiger Matthew Ward · Las Vegas, NVBuilt 1966 · S/N 1096 N3384XWendt Wesley A · Leavenworth, KSBuilt 1966 · S/N 1097 N3385XKelly Paul M · Granite Bay, CABuilt 1966 · S/N 3383 N3386ED Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N 17271526 N3387TWarner Stephen DBA · Pleasantville, PABuilt 1967 · S/N 17700687 N3388TKing Eric J · Zillah, WABuilt 1967 · S/N 17700688 N3388XRoth Joe D · Livingston, TXBuilt 1966 · S/N 1099 N3389EBarnfather James D · Sequim, WABuilt 1978 · S/N 17271528

Back to AD 80-25-07 R1