Skip to content

Registered aircraft · 54,019

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N1379UHigh Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17267050 N137ALLegends Air Center LLC · Bentonville, ARBuilt 1976 · S/N 17268125 N137CBEdmiston Brandon L · Murray, KYBuilt 1967 · S/N R1720146 N137ESWhobrey Andrew T · Bee Spring, KYBuilt 1967 · S/N 15067212 N137FRMoores Aerospace Solutions LLC · Statesboro, GAS/N 17276630 N137FST Aviation Services Inc · Canovanas, PRBuilt 1975 · S/N 17266030 N137LKStubby Wings LLC · Eden Prairie, MNBuilt 1981 · S/N 18504219 N137MCPoland Gilbert Guardian · Dothan, ALBuilt 1965 · S/N 337-0127 N137SAAlen Sergio Raul · Davie, FLBuilt 1958 · S/N 55633 N13804Henderson Jeannie · Colorado Springs, COS/N 17702470 N13805Gateway Flight Center LLC · Port Lavaca, TXBuilt 1974 · S/N 17263009 N13806Mpr Aviation LLC · Mcpherson, KSBuilt 1974 · S/N 17263010 N13807Blues Air LLC · Shelby, MSBuilt 1974 · S/N 17263011 N1380USky Clear LLC · Chicago, ILBuilt 1976 · S/N 17267051 N13810Charlie Lima 1 LLC · Jacksonville, FLBuilt 1974 · S/N 17263012 N13819Avco Patrol LLC · Lyndon, KSBuilt 1976 · S/N 17702471 N1381CEagle Sky Patrol Inc · Deadwood, SDBuilt 1977 · S/N 17702718 N13821Lexington Flying Club · Lexington, KYBuilt 1974 · S/N 17263015 N1382FCloud 9 Aviation LLC · Scenery Hill, PABuilt 1966 · S/N 17254877 N1382MRegan Arthur R · Green Valley, AZBuilt 1975 · S/N 18264305 N1382QRegistration Pending · Hubbard, OHRegistration pendingBuilt 1971 · S/N 15072682 N13830Iowa Lakes Community College · Estherville, IABuilt 1974 · S/N 17263017 N13834Hastings Air LLC · Hastings, NEBuilt 1974 · S/N 17263018 N1383URegistered aircraftBuilt 1976 · S/N 17267054 N13849Durkee Robert J · Prineville, ORBuilt 1974 · S/N 17263021 N1384CRedwood Area Flyers LLC · Redwood Falls, MNBuilt 1977 · S/N 17702719 N1384LCo Fire Aviation Leasing Inc · Fort Morgan, COBuilt 1978 · S/N 33701876 N1384SAdventure Aviation LLC · Fresno, CABuilt 1976 · S/N 18264946 N1385FRautio Ian · Intl Falls, MNS/N 17254880 N1385LWhiskey River Aviation LLC · Medford, ORBuilt 1978 · S/N 33701877 N1385MPecha James C · Binghamton, NYBuilt 1975 · S/N 18264307 N1385QRegister Trenton D · Wilmington, NCBuilt 1971 · S/N 15072685 N1385V303 Tango Charlie LLC · Newark, DEBuilt 1984 · S/N T30300266 N1385YCaracci Sam V Jr · Galesburg, ILS/N 17249085 N1386DDeford Shawn J · Hope, AKBuilt 1951 · S/N 20109 N1386EWitsoe Kathleen · Knoxville, TNBuilt 1982 · S/N 18268176 N1386MJohnson Shannon L · Granite Falls, MNBuilt 1971 · S/N 18260826 N1386QRegistration Pending · Wasilla, AKRegistration pendingBuilt 1971 · S/N 15072686 N1386SLangel Joseph J · Lakeville, MNBuilt 1976 · S/N 18264947 N13874Missionair LLC · Livingston, NYBuilt 1974 · S/N 17263026 N1387FEllis Jerald K · Fort Myers, FLBuilt 1966 · S/N 17254882 N1387MJ&D Aero LLC · Wilmington, DEBuilt 1975 · S/N 18264308 N1387QHendricks Adam · Plano, TXBuilt 1971 · S/N 15072687 N1387SGalaz Nick Anthony · Lake Havasu City, AZBuilt 1976 · S/N 18264948 N1387UCp Aircraft Leasing LLC · Danville, CABuilt 1976 · S/N 17267058 N1387YBi-County Ambulance Service Inc · Yuba City, CABuilt 1961 · S/N 17249087 N13884Triple F Aviation LLC · Scott City, KSS/N 17263028 N13887Jkg LLC · Murfreesboro, TNBuilt 1974 · S/N 17263029 N13889Carver Brian J · Rockwell City, IABuilt 1974 · S/N 17263030 N1388DGroceman Bernard F · Jackson, MOBuilt 1951 · S/N 19964

Back to AD 87-20-03 R2