Skip to content

Registered aircraft · 81,733

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N3515LBorchers Bruce A · Scotts Valley, CAS/N 0797 N3515NClauson Jesse W · Agawam, MABuilt 1967 · S/N 680079 N3515WHetherington Michael R · Fairbanks, AKS/N 32-398 N3515XSayre Mikko · Madison, WIBuilt 1966 · S/N 670053 N35163Eagle Sky Patrol Inc · Deadwood, SDBuilt 1975 · S/N 17702239 N35165N35165 LLC · Starkville, MSBuilt 1975 · S/N 17702241 N3516GHepler William J · Gratz, PABuilt 2001 · S/N 20608164 N3516KSteitz John III · Antioch, ILS/N 28-23602 N3516MAdamsup Aviation LLC · Wilmington, DEBuilt 1978 · S/N 32R-7885009 N3516XThompson Richard F · Boone, NCBuilt 1966 · S/N 670054 N3517MWilder Kirk E · Boonville, CABuilt 1947 · S/N 12-2384 N3517NTronaas Chris E · Hamilton, MTBuilt 1967 · S/N 680080 N3517PSmith Mark A · Bowling Green, KYBuilt 1946 · S/N 12-374 N3517SG & M Aircraft Inc · Wheat Ridge, COBuilt 2001 · S/N 17281083 N3517VSt Cloud State University Aero Club Inc · Saint Cloud, MNBuilt 2001 · S/N 17281082 N3517ZMeyers Carl A · Salem, CTBuilt 1960 · S/N 22-7414 N35182Beachy Michael H · Dundee, OHBuilt 1976 · S/N 177RG1045 N35183Stone Industrial Contractors Inc · Savannah, GABuilt 2001 · S/N 18281051 N35184Maliszewski William F · Independence, WIBuilt 2001 · S/N 18281002 N35185Stephens Brian A · Bruceville, INBuilt 1975 · S/N 17702252 N35186Mucci Eileen F · Wolcott, CTBuilt 1975 · S/N 17702253 N3518BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 20608163 N35191West Monte D · Coldspring, TXBuilt 1975 · S/N 17702255 N35192Huffman Robert V · Washington, DCBuilt 1975 · S/N 17702256 N35193Mccormack Duncan M · Sunfield, MIS/N 17702257 N35196Courtney Marshall Duchesne · Mission Hills, CABuilt 1975 · S/N 17702260 N35199Global Aerials Inc · Pembroke Pines, FLBuilt 1975 · S/N 17702261 N3519ABandy Clyde T · Orlando, FLBuilt 1953 · S/N 22-1791 N3519HGulino Thomas V · College Park, MDBuilt 1976 · S/N 20-1220 N3519ZSprott Robert L · Perkins, OKBuilt 1960 · S/N 22-7418 N351BBFinnerty Maurice E · Tabernacle, NJBuilt 1952 · S/N 20-867 N351BRRosenbaum Robert · Chilmark, MABuilt 1997 · S/N 18280045 N351CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283311 N351CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281386 N351GPSelby Chris A · Monticello, ARBuilt 1968 · S/N 17256918 N351GSKukowski Matthew P · Wheatland, WYBuilt 2000 · S/N 80713 N351JDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1997 · S/N 2707 N351JMSeal Benjamin A · Grapevine, TXBuilt 2011 · S/N 81655 N351JSRainier Flight Service LLC · Renton, WABuilt 2025 · S/N 172S13355 N351KCErickson Jason O · Mckinney, TXS/N 25114 N351MKNorth Star Aviation · Mankato, MNBuilt 2021 · S/N 2881440 N351VAVictory Aviation Club Inc · Hamilton, OHBuilt 1981 · S/N 28-8111056 N351WHDean John · Marana, AZBuilt 2002 · S/N 2309 N35203Sky Views Aviation LLC · Red Lodge, MTBuilt 1975 · S/N 17702263 N35205Riley John Roland · Ouray, COBuilt 1976 · S/N 177RG1046 N35206Mosaic Aviation LLC · Pelham, ALBuilt 2001 · S/N T18208089 N3520PWidner Jack A · Stanley, NCBuilt 1955 · S/N 22-3274 N3520WLyttle John W Jr · Chehalis, WABuilt 1966 · S/N 32-404 N3520ZWaldo Charles N · West Ossipee, NHBuilt 1960 · S/N 22-7420 N35211Ballester Alexis R · Mayaguez, PRBuilt 1975 · S/N 17702267

Back to AD 81-18-04 R2