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.

N5508WEkkel Bob J · Newaygo, MIBuilt 1962 · S/N 28-596 N55094Remedy Aviation LLC · Langford, SDBuilt 1973 · S/N 28-7325322 N55096Robinson Jeffrey M · Scottsboro, ALBuilt 1973 · S/N 28-7305311 N5509FAhs Aero LLC · Leo, INS/N 28-24850 N5509WKitts John L · New Braunfels, TXBuilt 1962 · S/N 28-597 N550DDSaratoga Aviation LLC · Rocky Mount, NCBuilt 1996 · S/N 32-46037 N550FLKennedy Adam B · Des Moines, WAS/N 28-7125387 N550PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842106 N5510FHughes Arlen L · Saratoga, WYBuilt 1968 · S/N 28-24851 N5510VForest Aviation LLC · Troy, MIS/N 32R-7780336 N5510WMilius Douglas L · Oshkosh, WIBuilt 1962 · S/N 28-598 N55115Gleason Ronald L · Willows, CAS/N 28-7305313 N55116Stick And Rudder Aviation LLC · Hale, MOBuilt 1973 · S/N 28R-7335182 N55117Smathers Jason R · Redwood City, CABuilt 1973 · S/N 28-7310116 N5511FSmith Jimmy A Jr · Albemarle, NCBuilt 1968 · S/N 28-24852 N55124Stroud Stephen D · Independence, MOS/N 28-7325329 N55127Lands James M · Stoutsville, OHBuilt 1973 · S/N 28-7305314 N55128Schumacher Clinton D · Chatfield, MNS/N 28-7305317 N55129Bauer Roger · Saint Germain, WIBuilt 1973 · S/N 28-7305319 N5512FWestergaard Wayne B · Craig, NEBuilt 1968 · S/N 28-24854 N5512JWhitaker Robbie L · Brooklet, GABuilt 1968 · S/N 32-973 N5512URegistration Pending · Smiths Station, ALRegistration pendingBuilt 1969 · S/N 28-26223 N5512VCabaniss Tex P Jr · Cypress, TXBuilt 1977 · S/N 28-7725240 N5512WMoy Jack M · Los Angeles, CABuilt 1962 · S/N 28-600 N55131Sansone Gary A · Fort Laramie, WYBuilt 1973 · S/N 28R-7335184 N55135Air Ventures Flying School LLC · Smithfield, RIBuilt 1973 · S/N 28-7325331 N55136Alberio Angela E · Bloomington, MNBuilt 1973 · S/N 28-7325332 N55139Hanson Mark A · Snelling, CABuilt 1973 · S/N 28-7305320 N5513UShi Yi · Walnut, CABuilt 1969 · S/N 28-26225 N5513VRenaldo Michael T · Stafford, VABuilt 1977 · S/N 28-7716181 N5513WJohnson Thomas D · Pilot Mountain, NCBuilt 1962 · S/N 28-601 N55140Di Giorgio Thomas J Jr · Lopez Island, WABuilt 1973 · S/N 28-7305321 N55148Lierle Sidney D · Clearlake, CABuilt 1973 · S/N 28-7325333 N55149County 17 Aviators LLC · Gillette, WYS/N 28-7325334 N5514FWingrove Rodney W · Vincent, OHBuilt 1968 · S/N 28-24856 N5514UCheckers Investments Inc · Edmond, OKBuilt 1969 · S/N 28-26226 N55150Alexander Dennis K · Gallatin, TNBuilt 1973 · S/N 28-7305322 N55151Learn 2 Fly LLC · Cantonment, FLBuilt 1973 · S/N 28-7415001 N55154Kanpahem Aviation LLC · Hawkins, TXBuilt 1973 · S/N 28R-7335187 N55159Rasmussen Paul H · Mitchell, SDBuilt 1973 · S/N 32-7340103 N55163Jackson Donald W · Carthage, MSBuilt 1973 · S/N 28-7325335 N55166Volando LLC · Columbia, MOBuilt 1973 · S/N 28-7325338 N55167Flyboys Nevada LLC · Henderson, NVBuilt 1973 · S/N 28-7305325 N5516FMoore Marcus · Auburn, ALS/N 28-24858 N5516JRobarge Andrew Michael · Crown Point, INBuilt 1967 · S/N 32-925 N5516UHicks David A · Beaver Dam, WIBuilt 1969 · S/N 28-26228 N55173Dareing Chon · San Antonio, TXBuilt 1973 · S/N 28-7305327 N55176Hall Davis · Mobile, ALBuilt 1973 · S/N 28R-7335189 N55177Saunders Ivan J · Margate, FLBuilt 1973 · S/N 28R-7335190 N5517FMccarthy Mark C · Russellville, ARS/N 28-24859

Back to AD 87-08-08 R3