Skip to content

Registered aircraft · 54,017

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.

N5265RMoss Hill Airport Inc · Kinston, NCBuilt 1974 · S/N 17263479 N52660Yancey Steven Hunter · Helenwood, TNBuilt 1977 · S/N 177RG1235 N52662Aston Stuart A · New Braunfels, TXBuilt 1977 · S/N 177RG1236 N52663Registration Pending · Cedar Key, FLRegistration pendingS/N 177RG1237 N52667Noe Daniel P · Pittsburgh, PABuilt 1977 · S/N 177RG1240 N52669F Sharp Aviation LLC · New Baltimore, MIBuilt 1977 · S/N 177RG1242 N5266DColemanation Investments LLC · Naperville, ILBuilt 1979 · S/N 17272483 N5266ENatchez Flight Training LLC · Natchez, MSBuilt 1978 · S/N 17271805 N5266KCorsicana Aviation Training Services LLC · Corsicana, TXBuilt 1980 · S/N 17274037 N5266LIlmberger Stephen R · San Leandro, CABuilt 1980 · S/N 15284284 N5266UN5266u LLC · Brookfield, ILBuilt 1980 · S/N 172RG0312 N52671Carver Aero LLC · Muscatine, IABuilt 1981 · S/N 17274577 N52674Miller Glenn E Trustee · Albany, ORBuilt 1973 · S/N 18262760 N52677Spencer Joseph T Jr · Felton, CAS/N 18262763 N5267EBrudelie Alan C · Lewisville, MNBuilt 1978 · S/N 17271806 N5267FColeman Timothy James · Cornwall On Hudson, NYBuilt 1965 · S/N 17253390 N5267HNichani Nikhil Deepak · Livingston, NJBuilt 1981 · S/N 18267864 N5267QGibson Aviation Services LLC · Hudson, WIBuilt 1972 · S/N 15073167 N5267SAviation Psych LLC · Neptune Beach, FLBuilt 1980 · S/N R18201530 N5267VN5267v LLC · Northbrook, ILBuilt 1975 · S/N 21060886 N52680Harris John Q · Tucson, AZBuilt 1977 · S/N 177RG1246 N52681Clough Robert · Woodinville, WABuilt 1973 · S/N 18262766 N52683Cobb John Mark · Fayetteville, TNBuilt 1981 · S/N 17274579 N52684Altair Advanced Industries Inc · Bellingham, WABuilt 1977 · S/N 177RG1248 N52685Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17274580 N52687Abby Enterprises LLC · Plantsville, CTBuilt 1973 · S/N 18262770 N52689Dyberg Mike DBA · Mount Vernon, WABuilt 1973 · S/N 18262771 N5268FVincennes University · Indianapolis, INBuilt 1965 · S/N 17253391 N5268HGrander Aviation LLC · Panama City Beach, FLBuilt 1975 · S/N 17265389 N5268JReach For Skies LLC · San Antonio, TXBuilt 1980 · S/N 17273751 N5268KSorbi Aviation Inc · El Cajon, CABuilt 1980 · S/N 17274038 N5268RJohnson Steven D · Oklahoma City, OKS/N 17263482 N52695Farley Ryan P · Cumberland, RIBuilt 1977 · S/N 177RG1251 N52696Sladko Jeffrey · Battle Ground, WABuilt 1977 · S/N 177RG1252 N52698Marshall Gregory · Farmington, MEBuilt 1973 · S/N 18262779 N5269DGeorges Aviation Services Inc · Honolulu, HIBuilt 1977 · S/N 177RG1249 N5269ERocky Pointe Logistics LLC · Hayden, IDBuilt 1959 · S/N 50569 N5269SCanyon Blue LLC · Sharpsburg, GABuilt 1980 · S/N R18201531 N526BBBrookover James R · Hartville, OHBuilt 1977 · S/N 177RG1239 N526CHSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N P21000662 N526FRoush Heith · Cabot, ARS/N 17700932 N526LTCheatum Roger K · Port Orange, FLBuilt 1975 · S/N 18264197 N526MPS Brown Inc · Durant, OKBuilt 1965 · S/N 21058630 N526PLEdson Aviation Group LLC · Jericho, VTBuilt 1959 · S/N 50562 N526UJsrs Holdings LLC · Las Cruces, NMBuilt 1973 · S/N 18262708 N526VBGilbert Benjamin N Trustee · Chico, CABuilt 1977 · S/N 18265954 N526WRFlorida And Caribbean Flight Training LLC · Punta Gorda, FLS/N 17269371 N52700Air Transport Inc DBA · Las Vegas, NVS/N 17274583 N52701Cannon Michael A DBA · Blythe, CABuilt 1981 · S/N 17274584 N52702Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17274585

Back to AD 87-20-03 R2