Skip to content

Registered aircraft · 6,349

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-02-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-25-02-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-25-02-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-25-02-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-25-02-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-25-02-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.

N9649LGulfstream Aerospace Corp · Savannah, GABuilt 1973 · S/N AA1B-0149 N9649SHowell Alice R · Bainbridge, GAS/N 396 N9650LKennedy Christopher D · Marlow, OKBuilt 1973 · S/N AA1B-0150 N9650UFrench James R · Eads, TNBuilt 1977 · S/N AA1C0087 N9651AMarty Air LLC · Vero Beach, FLBuilt 1950 · S/N 15481 N9651LSmith Warren D · Oak Harbor, WABuilt 1973 · S/N AA1B-0151 N9651TPilot Pros Inc · Miami, FLBuilt 1978 · S/N 38-78A0151 N9652LLoesch William J · Saint Louis, MOBuilt 1973 · S/N AA1B-0152 N9653LMahoney Anthony J · Wichita, KSBuilt 1973 · S/N AA1B-0153 N9653SNy Barnstormers LLC · Maine, NYBuilt 1966 · S/N 314 N9657LLongobardi Vito A · Westport Island, MES/N AA1B-0157 N965AAWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282465 N9660SHughes Alan J · Edison, OHBuilt 1966 · S/N 245 N9663LPhlindy Investments LLC · Eagle River, AKBuilt 1973 · S/N AA1B-0163 N9665SDendy Dwight E · Caledonia, ILBuilt 1966 · S/N 251 N9666UGlass Gene A · Lafayette, LABuilt 1977 · S/N AA1C0090 N9667LPelot Samuel Boykin Jr · Sebring, FLBuilt 1973 · S/N AA1B-0167 N9667UBeall James C · Hollywood, SCS/N AA1C0091 N9669GSweet Anthony E · Peyton, COS/N 18-2379 N9670LStewart Roddie Lii · Newnan, GABuilt 1973 · S/N AA1B-0170 N9670SDowns Steve M · Camden, TNBuilt 1966 · S/N 397 N9671LRegistration Pending · Chambersburg, PARegistration pendingBuilt 1973 · S/N AA1B-0171 N9674TMichael Guetersloh · Sandia, TXBuilt 1978 · S/N 38-78A0156 N9675LGunter Parnie L Jr · Watauga, TXBuilt 1973 · S/N AA1B-0175 N9676LGordon Clyde B Jr · Westerly, RIBuilt 1973 · S/N AA1B-0176 N9679LGo Fast Dont Suck LLC · Magnolia, DES/N AA1B-0179 N9679SBistline John A · Cedar City, UTS/N 273 N967CMDonaldson Charles A · Clay City, KYBuilt 1972 · S/N 833-72 N9682SRoethlisberger John · Beaver Falls, PABuilt 1966 · S/N 469 N9685SSymond Clarence B · Eastover, NCBuilt 1966 · S/N 551 N9686SAirpro Aviation LLC · Cross Lake Twp, MEBuilt 1966 · S/N 41 N9689LAmborski Joshua J · Woodville, OHBuilt 1973 · S/N AA1B-0189 N968MSMount San Antonio College Associated · Walnut, CABuilt 1977 · S/N 15281080 N9690LMarkey James T · Clintondale, NYBuilt 1973 · S/N AA1B-0190 N9690SAck & Co LLC · East Helena, MTBuilt 1966 · S/N 418 N9693SSale Reported · Kenmare, NDSale reportedBuilt 1966 · S/N 426 N9695TCavallaro Marco · Amarillo, TXBuilt 1978 · S/N 38-78A0157 N9697LBroadwell Eric · Woodstock, GABuilt 1973 · S/N AA1B-0197 N9698LGoertz Anton O · Santa Fe, NMS/N AA1B-0398 N9699SBaumann Matt · Chewelah, WABuilt 1966 · S/N 430 N9699UDoll Electric Co Inc · Murphys, CABuilt 1977 · S/N AA1C0101 N969BCCohen Brad · Palm Harbor, FLBuilt 2014 · S/N 6-5803 N96BZBerencsi Tibor C · Edison, NJBuilt 1996 · S/N 10-96-01 N96EJDorris Terry · Greenbrier, TNS/N 001 N96HSKundert Matthew J · Rochester, MNBuilt 1989 · S/N 1190 N96RMMitchell Ronald L · East Leroy, MIBuilt 1995 · S/N 001 N9709UMvm Flyers LLC · East Quogue, NYS/N AA1C0103 N970SETraining Planes LLC · Tampa, FLBuilt 1979 · S/N 15283609 N9717TLehmann Peter E · Pembroke, MEBuilt 1978 · S/N 38-78A0170 N971FMFreeway Airport Inc · Mitchellville, MDBuilt 1977 · S/N 15281185

Back to AD 80-25-02 R2