OpenAirDocs.org
AD 96-10-01 R1

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
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.

N5503UFuller Christopher Jason · Destin, FLBuilt 1969 · S/N 28-26211N55041Napier Clarence M · Mount Juliet, TNBuilt 1973 · S/N 28-7305297N55042Rohrbaugh Mark A · Lenexa, KSBuilt 1973 · S/N 28-7305298N55044Yale Aviation Inc · New Haven, CTBuilt 1973 · S/N 28-7305299N5504FWieselquist Kermit L · Westford, MABuilt 1968 · S/N 28-24843N5504WTaylor Deric C · Seguin, TXBuilt 1962 · S/N 28-591N55055Martan LLC · Kansas City, MOBuilt 1973 · S/N 28-7305301N55057Smooth Air LLC · Churubusco, INBuilt 1973 · S/N 28-7305302N5505FSerafinowicz Ronald P · Gilbert, AZBuilt 1968 · S/N 28-24844N5505UPaper Plane Aviation LLC · Avon Park, FLBuilt 1969 · S/N 28-26215N5505WPerez Daniel E · Parsons, KSBuilt 1962 · S/N 28-592N55064Western Skyways Inc · Montrose, COBuilt 1973 · S/N 28-7325317N55066Premier Capital Enterprises LLC · Hurricane, UTS/N 28-7305303N5506UHumberto Moreno · Mulberry, FLBuilt 1969 · S/N 28-26214N5506WMchatton Dret A · Redding, CABuilt 1962 · S/N 28-593N55078Tiritilli Robert · Mission Viejo, CABuilt 1973 · S/N 28-7325320N55080Keath Brian S · Kansas City, MOBuilt 1973 · S/N 28-7305305N55087Fosso Christopher M · Glendale, AZBuilt 1973 · S/N 28-7305308N5508WEkkel Bob J · Newaygo, MIBuilt 1962 · S/N 28-596N55094Remedy Aviation LLC · Langford, SDBuilt 1973 · S/N 28-7325322N55096Robinson Jeffrey M · Scottsboro, ALBuilt 1973 · S/N 28-7305311N5509FAhs Aero LLC · Leo, INS/N 28-24850N5509WKitts John L · New Braunfels, TXBuilt 1962 · S/N 28-597N550FLKennedy Adam B · Des Moines, WAS/N 28-7125387N5510FHughes Arlen L · Saratoga, WYBuilt 1968 · S/N 28-24851N5510WMilius Douglas L · Oshkosh, WIBuilt 1962 · S/N 28-598N55115Gleason Ronald L · Willows, CAS/N 28-7305313N5511FSmith Jimmy A Jr · Albemarle, NCBuilt 1968 · S/N 28-24852N55124Stroud Stephen D · Independence, MOS/N 28-7325329N55127Lands James M · Stoutsville, OHBuilt 1973 · S/N 28-7305314N55128Schumacher Clinton D · Chatfield, MNS/N 28-7305317N55129Bauer Roger · Saint Germain, WIBuilt 1973 · S/N 28-7305319N5512FWestergaard Wayne B · Craig, NEBuilt 1968 · S/N 28-24854N5512URegistration Pending · Smiths Station, ALRegistration pendingBuilt 1969 · S/N 28-26223N5512VCabaniss Tex P Jr · Cypress, TXBuilt 1977 · S/N 28-7725240N5512WMoy Jack M · Los Angeles, CABuilt 1962 · S/N 28-600N55135Air Ventures Flying School LLC · Smithfield, RIBuilt 1973 · S/N 28-7325331N55136Alberio Angela E · Bloomington, MNBuilt 1973 · S/N 28-7325332N55139Hanson Mark A · Snelling, CABuilt 1973 · S/N 28-7305320N5513UShi Yi · Walnut, CABuilt 1969 · S/N 28-26225N5513WJohnson Thomas D · Pilot Mountain, NCBuilt 1962 · S/N 28-601N55140Di Giorgio Thomas J Jr · Lopez Island, WABuilt 1973 · S/N 28-7305321N55148Lierle Sidney D · Clearlake, CABuilt 1973 · S/N 28-7325333N55149County 17 Aviators LLC · Gillette, WYS/N 28-7325334N5514FWingrove Rodney W · Vincent, OHBuilt 1968 · S/N 28-24856N5514UCheckers Investments Inc · Edmond, OKBuilt 1969 · S/N 28-26226N55150Alexander Dennis K · Gallatin, TNBuilt 1973 · S/N 28-7305322N55163Jackson Donald W · Carthage, MSBuilt 1973 · S/N 28-7325335N55166Volando LLC · Columbia, MOBuilt 1973 · S/N 28-7325338N55167Flyboys Nevada LLC · Henderson, NVBuilt 1973 · S/N 28-7305325
Back to AD 96-10-01 R1