Skip to content

Registered aircraft · 22,413

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.

N5829UFarrell Mark O · Pittsburgh, PABuilt 1969 · S/N 28-26660 N582AMCesbron Pierre · ParisS/N 32-8006041 N582BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881959 N582VWingcap LLC · Ferguson, MOS/N 28R-7703332 N5830WWard Orval G · Bentonville, ARBuilt 1965 · S/N 28-2148 N5831WSonafrank Eric J · Somerset, INBuilt 1965 · S/N 28-2149 N5832UBecker Randall T · Santa Rosa, CABuilt 1970 · S/N 28-26663 N5833WJts Aircraft LLC · Rock Hill, SCBuilt 1965 · S/N 28-2159 N5834UNewburn William A Jr · Fresno, CABuilt 1969 · S/N 28-26665 N5834WDowdy Joseph N · Blacksburg, VABuilt 1965 · S/N 28-2186 N5837UDeblass Christopher C · Cranford, NJBuilt 1969 · S/N 28-26668 N5838WJohn Andrew P · Auburn, MES/N 28-2207 N583CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881132 N583FLSotomayor Edwin · Lacey, WABuilt 1971 · S/N 28-7125438 N5840UTall Timber Flying Service LLC · Kalispell, MTBuilt 1970 · S/N 28-26671 N5841WDestination Flyer LLC · Memphis, TNBuilt 1965 · S/N 28-2216 N5842WFrakes Enterprises · Happy, TXBuilt 1965 · S/N 28-2221 N5843UOnyx Aviation LLC · North Fort Myers, FLS/N 28-26674 N5843WSkyunityventures LLC · Richmond Hill, NYBuilt 1965 · S/N 28-2247 N5844WSmith William H · Weimar, TXBuilt 1965 · S/N 28-2237 N5846FDunning Steve L · Hopkinsville, KYBuilt 1976 · S/N 28-7790138 N5847UFly Vermont LLC · Swanton, VTBuilt 1969 · S/N 28-26678 N5847WReed Charles W · Elizabeth City, NCBuilt 1965 · S/N 28-2286 N5848VSheffield David A · Silsbee, TXBuilt 1977 · S/N 32R-7780368 N5848WLedbetter Mark W · Garfield, ARBuilt 1965 · S/N 28-2292 N5849FGng LLC · Arlington, INBuilt 1976 · S/N 28-7790139 N5849WHomic Michael J · Edmond, OKBuilt 1965 · S/N 28-2293 N584FLQuantum Aviation Services LLC · Lakewood Ranch, FLBuilt 1971 · S/N 28-7125439 N584SShobe Andrew S A · Clarksville, MDBuilt 1977 · S/N 28R7737112 N584SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881403 N5850UMarfair LLC · Freeport, TXBuilt 1970 · S/N 28-26681 N5850WCaside Aviation LLC · Brooklyn, NYBuilt 1965 · S/N 28-2296 N5851UFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1969 · S/N 28-26683 N5851VMcconnell Thomas E · Grass Valley, CABuilt 1977 · S/N 28-7715273 N5851WCameron Hugh R · Gainesboro, TNBuilt 1965 · S/N 28-2308 N5852WFerguson Carl R · Waupaca, WIBuilt 1965 · S/N 28-2312 N5853UPost Jay M · Greenfield, OHBuilt 1970 · S/N 28-26685 N5854FBravo Sierra LLC · Middletown, DES/N 32R-7780021 N5854UMagic Valley Aero Club Inc · Twin Falls, IDBuilt 1970 · S/N 28-26686 N5854WAtluas LLC · Dallas, TXBuilt 1965 · S/N 28-2333 N5855WZachry David · West Point, GABuilt 1965 · S/N 28-2358 N5856WSergeant Mary E · Harvard, ILBuilt 1965 · S/N 28-2361 N5857VHague Parkerson B · Virginia Beach, VAS/N 28-7716207 N5858WPaulisin George W · Crossville, TNBuilt 1965 · S/N 28-2368 N5859VHaney Paul · Navarre, FLBuilt 1977 · S/N 28-7790504 N585AWChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843934 N585DEHouston Fire Aviators LLC · Houston, TXBuilt 1968 · S/N 28-4660 N585GEWayne Mogg Inc · Parker, AZFirst renewal noticeBuilt 2018 · S/N 2881009 N585TLbl Flyers LLC · Depoe Bay, ORBuilt 1974 · S/N 28-7415285 N586Poppino James D · Titusville, FLBuilt 1967 · S/N 28-23892

Back to AD 87-08-08 R3