Skip to content

Registered aircraft · 22,428

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N1358TMizera David · Hillsboro, ILBuilt 1972 · S/N 28-7225481 N1359TNahir Ehud · Woodland Hills, CABuilt 1972 · S/N 28-7205288 N135DGSg Solutions LLC · Reno, NVBuilt 1977 · S/N 28R-7803122 N135EG305 Aviation Group Inc · Miami, FLS/N 28-8290170 N1360TDibrino Ruth G · Hillsboro, ORBuilt 1972 · S/N 28R-7235269 N1362HRegion Flyers LLC · Valparaiso, INS/N 28-7716018 N1367TN1367t LLC · Mount Dora, FLBuilt 1972 · S/N 28R-7235271 N136AVHarford Archer Owners Group LLC · Bel Air, MDBuilt 1984 · S/N 28-8590004 N136FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290171 N136VPWartman Steven · Sandia Park, NMBuilt 1965 · S/N 28-21128 N1371TSaviortree House Ministries · Coarsegold, CABuilt 1972 · S/N 28-7225485 N1376TSteflik Timothy · New Smyrna Beach, FLBuilt 1972 · S/N 28-7225486 N1377HParis Air Inc · Vero Beach, FLS/N 28-7716019 N1377TTheroux Theodore N · Rice Lake, WIBuilt 1972 · S/N 28-7225487 N1379TGordon William E · Summit, NJBuilt 1972 · S/N 28-7205290 N137ATChamerlik William S · Spencer, TNBuilt 1977 · S/N 28-7816087 N137BCJrnd Corp · Lewes, DEBuilt 2003 · S/N 2843584 N137CCMore Right Rudder LLC · Sioux City, IABuilt 1977 · S/N 28R-7737065 N137NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 28010008 N137SDHann Joseph C · Flemington, NJBuilt 1995 · S/N 3246002 N137VPLoftfield Ronald E · Nondalton, AKBuilt 1965 · S/N 28-21131 N1382HCaba Edward M · Malvern, PAS/N 28-7790309 N1385TRayfield Charles · Downingtown, PABuilt 1972 · S/N 28R-7235274 N1386HRodriguez Luis D · Davenport, FLBuilt 1977 · S/N 28-7790310 N1386TGeorgia Aviation Authority · Eastman, GABuilt 2003 · S/N 2844101 N1388TNora Jet LLC · Granbury, TXBuilt 1972 · S/N 28-7205293 N1389HDouble Dd Arrow Aviation LLC · Graham, TXS/N 28R-7703024 N1389TR And S Flying LLC · Westfield, MABuilt 1972 · S/N 28-7205292 N138BCUniversidad Interamericana De Puerto Rico · Bayamon, PRBuilt 2003 · S/N 2843580 N138BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881955 N138FCUsda Forest Service Fepp · Tallahassee, FLBuilt 1982 · S/N 28-8290102 N138SFUnderwood Mark A · Kennewick, WAS/N 28-20998 N138TPTwo Pauls LLC · Forked River, NJBuilt 1968 · S/N 28-25301 N138VAMysky LLC · Saint Louis, MOBuilt 2023 · S/N 28020112 N1391TAbita Air LLC · Covington, LABuilt 1972 · S/N 32-7240117 N1395TLegacy Aerospace Industries LLC · Miami, FLS/N 28R-7235277 N1399TLauff Samuel Jr · Ocala, FLBuilt 1972 · S/N 28R-7235278 N139DMMurillo Raymond A · Pico Rivera, CABuilt 1969 · S/N 28R-35262 N139FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290174 N139GGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N 28-8211036 N139SNMccullough Jacob D · Lockhart, TXBuilt 1965 · S/N 28-2184 N139YPSmuzzle Air LLC · Longboat, FLBuilt 1977 · S/N 28R-7703364 N13KFRockwood Blake T · Fort Worth, TXBuilt 1965 · S/N 28-2396 N13KRKaplan Ronald · Palm Beach Gardens, FLBuilt 1967 · S/N 28-4363 N13MPPowell & Powell LLC · Northport, ALS/N 28-7515384 N13RGIsland Piper Llp · St Helena Is, SCBuilt 1972 · S/N 28-7310055 N13WStl LLC · Savoy, ILBuilt 2001 · S/N 3246185 N13WRBillys Blessing LLC · Louisburg, NCBuilt 2000 · S/N 3246154 N14033Nomadic Flight Training LLC · New Castle, DES/N 28-25388 N1404HMiller Shawn C · Milaca, MNS/N 28-7716023

Back to AD 87-08-08 R3