Skip to content

Registered aircraft · 6,916

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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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.

N5066PDelaware Aviation LLC · Sidney, NYBuilt 1958 · S/N 24-72 N5066TLee Miesner Aviation LLC · Park Hills, MOBuilt 1972 · S/N 28R-7235190 N5067SSinatsch Christian C · Saint Augustine, FLS/N 28R-35810 N5069SMccarron Michael · Cary, ILBuilt 1971 · S/N 28R-7135074 N5074PShingledecker Robert K II · Ozark, ARBuilt 1958 · S/N 24-80 N5078PPutnam Andrew L · New Limerick, MEBuilt 1958 · S/N 24-84 N507THLeyva Maria · Edgewater, FLBuilt 1971 · S/N 34-7250037 N5081SDream Factory Aviation Inc · Henderson, NVBuilt 1971 · S/N 28R-7135081 N5083SRiser Air LLC · Stillwater, MNBuilt 1971 · S/N 28R-7135082 N5085SHall Thomas K · Beaufort, NCBuilt 1971 · S/N 28R-7135085 N5086SAero Air Inc · Salt Lake City, UTBuilt 1971 · S/N 28R-7135086 N5088CMike Golf Holdings LLC · Pinellas Park, FLBuilt 1964 · S/N 30-497 N5088PKesser Gilbert M · Culpeper, VABuilt 1958 · S/N 24-94 N5088SSwaz Aviation LLC · Mesa, AZBuilt 1971 · S/N 28R-7135089 N5089STye Richard Ray · Silverado, CABuilt 1971 · S/N 28R-7130004 N5090SSturm Neal M · Randolph, NJBuilt 1971 · S/N 28R-7135091 N5091PSpicuzza Robert A · Waterford, MIBuilt 1958 · S/N 24-100 N5093PAir Chutney LLC · Waynesboro, VABuilt 1958 · S/N 24-102 N5094SBoraam Aviation Inc · Prospect Heights, ILBuilt 1971 · S/N 28R-7135094 N5098SBadenhope John R · Greeneville, TNS/N 28R-7135097 N5099PSelinger Richard L · Murrieta, CABuilt 1958 · S/N 24-109 N509DBMaycroft David E · Cary, ILBuilt 1971 · S/N 28R-7135096 N50TDPa-30 LLC · Appleton, WIBuilt 1965 · S/N 30-827 N50ZMAmerican Air Academy Inc · Merritt Island, FLBuilt 1980 · S/N 348070168 N5100PHuntcliff Air Services LLC · Atlanta, GABuilt 1958 · S/N 24-105 N5100THaynes Michael H · Anniston, ALBuilt 1972 · S/N 28R-7235191 N5101SWaddill John W · Houston, TXBuilt 1971 · S/N 28R-7135103 N5107PStranton Air LLC · Harvard, ILS/N 24-117 N5107SJdc Aviation LLC · Upland, CABuilt 1971 · S/N 28R-7135108 N5107TIron Horse Leasing LLC · Platteville, WIS/N 28R-7235192 N510DROriley Rickalan H · Encino, CABuilt 1978 · S/N 28R-7803304 N510PChaos Holbrook Aviation LLC · Norman, OKBuilt 1979 · S/N 34-7970268 N510TEPluid Darwin D · Eureka, MTBuilt 1977 · S/N 28R-7803124 N510THRegistration Pending · Oxford, CTRegistration pendingBuilt 1975 · S/N 28R-7535221 N5114PParris David T · Virginia Beach, VABuilt 1958 · S/N 24-126 N5114SConner W Larry · Los Lunas, NMBuilt 1971 · S/N 28R-7135148 N51157Air Travel Management LLC · Lemont Furnace, PABuilt 1979 · S/N 34-7970392 N5115PSmith James Kelly · Newark, OHBuilt 1958 · S/N 24-127 N5115SBridgeport Flying Club LLC · Bridgeport, CABuilt 1971 · S/N 28R-7135149 N5117PMarsteller Michael A · Lugoff, SCBuilt 1959 · S/N 24-130 N5118PMeng Marvin Allen Jr · Edwardsville, ILBuilt 1958 · S/N 24-131 N511JRN511jr LLC · Taylor, MOBuilt 1976 · S/N 32R-7680476 N5124SCalvert David · Livermore, CABuilt 1971 · S/N 28R-7135154 N5125SSlade Clark K · Pinckney, MIBuilt 1971 · S/N 28R-7135157 N5126PElie Jonathan · Hopewell Junction, NYBuilt 1958 · S/N 24-139 N5128PSchafer David · Northport, ALBuilt 1958 · S/N 24-141 N512CSR Scott Hoffman/Silverado Transportation LLC · Kalispell, MTBuilt 1977 · S/N 28R-7837048 N5130PWhite Guy B · Waxahachie, TXBuilt 1958 · S/N 24-143 N5131SForan Dana Francis · Bement, ILS/N 28R-7135158 N5132PMccormick Geoffrey D · Goodyear, AZBuilt 1958 · S/N 24-145

Back to AD 97-01-01 R1