Skip to content

Registered aircraft · 8,139

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:96-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-10-01-R1') 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:96-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-10-01-R1')
  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:96-10-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-10-01-R1')
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.

N5813WStothers Brian · Lake Havasu City, AZBuilt 1964 · S/N 28-1954 N5814UAnderson Timothy B · Cold Spring, KYBuilt 1970 · S/N 28-26644 N5814WP&K Enterprises LLC · Madison Heights, VABuilt 1964 · S/N 28-1965 N5815UMiller William W Jr · Henderson, NVBuilt 1969 · S/N 28-26643 N5816UHarsimran Singh · Las Vegas, NVBuilt 1970 · S/N 28-26645 N5817WDow Jeff W · Port Hadlock, WABuilt 1964 · S/N 28-1988 N5819UOn Final Aviation LLC · Brookland, ARBuilt 1970 · S/N 28-26649 N5819WKee Anthony S · Greenup, KYBuilt 1964 · S/N 28-1997 N5820UScarpelli Leonard · Lakewood, ILBuilt 1970 · S/N 28-26650 N5820WRed Baron Aviation LLC · Pine Bush, NYBuilt 1964 · S/N 28-2000 N5821WEnander Johannes T · Grenora, NDS/N 28-2033 N5822UCurliss James P · Quincy, MABuilt 1970 · S/N 28-26653 N5823UNewton Donald S · Elk Grove, CABuilt 1970 · S/N 28-26654 N5823WHill Travis R · Aledo, TXBuilt 1964 · S/N 28-2070 N5824ULindaman Craig C · San Luis Obispo, CABuilt 1970 · S/N 28-26655 N5824WBowman William K · Morrison, TNBuilt 1965 · S/N 28-2107 N5825TTeshima Mark William · Clovis, NMS/N 28-1595 N5825UGantz Clayton B · Forestville, CABuilt 1970 · S/N 28-26656 N5825WIndian Trucking Company Inc · Destin, FLBuilt 1965 · S/N 28-2113 N5826UHill Christopher L · Milner, GABuilt 1969 · S/N 28-26657 N5829UFarrell Mark O · Pittsburgh, PABuilt 1969 · S/N 28-26660 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 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 N5847UFly Vermont LLC · Swanton, VTBuilt 1969 · S/N 28-26678 N5847WReed Charles W · Elizabeth City, NCBuilt 1965 · S/N 28-2286 N5848WLedbetter Mark W · Garfield, ARBuilt 1965 · S/N 28-2292 N5849WHomic Michael J · Edmond, OKBuilt 1965 · S/N 28-2293 N584FLQuantum Aviation Services LLC · Lakewood Ranch, FLBuilt 1971 · S/N 28-7125439 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 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 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

Back to AD 96-10-01 R1