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.

N9917WFlydunn.Com Inc · Jacksonville, FLBuilt 1967 · S/N 28-23439N9921WPhoenix Composite Solutions LLC · Oscoda, MIS/N 28-23443N9924WFlydunn.Com Inc · Jacksonville, FLBuilt 1967 · S/N 28-23448N9925WBigler Danny L · Owasso, OKBuilt 1967 · S/N 28-23449N9929WLalor David P · Montello, WIBuilt 1967 · S/N 28-23453N992TFFriendswood Aviation LLC · Friendswood, TXBuilt 1974 · S/N 28-7405237N9933WSantangelo Troy M · Akron, PABuilt 1967 · S/N 28-23477N9936WBrown Thrasher Aero LLC · Midland, GAS/N 28-23480N99374Martin Douglas C · Boca Raton, FLBuilt 1965 · S/N 28-20942N9938WBerger Alexander W · Richmond, VAS/N 28-23482N9939WHoward Dwight · Beverly Hills, FLBuilt 1967 · S/N 28-23483N9940WStaley Harvey Russell · Brandon, FLBuilt 1967 · S/N 28-23484N9942WMccafferty R Joseph · Winfield, MOBuilt 1967 · S/N 28-23486N9946WHangar 0205 Inc · Calhoun, GABuilt 1967 · S/N 28-23491N9947WDwinal Gary Lee · Lisbon, MEBuilt 1967 · S/N 28-23492N9950WPlane Jane Aviation LLC · Lincoln, NEBuilt 1967 · S/N 28-23495N9961WViper Enterprises LLC · Rolla, MOBuilt 1967 · S/N 28-23508N9962WSuggs Kaycen M · Grifton, NCBuilt 1967 · S/N 28-23509N9964WRawlins James III · Saint Charles, MOBuilt 1967 · S/N 28-23511N9968WWitter Gregory J · Overton, NVBuilt 1967 · S/N 28-23515N996JHMountain John · Wrightstown, WIBuilt 1971 · S/N 28-7125529N9970WSkrabacz Joseph A · Niceville, FLBuilt 1967 · S/N 28-23517N9971WMorris Elaine · Moorestown, NJBuilt 1967 · S/N 28-23518N9975WPoole Terrell W · Rigby, IDBuilt 1967 · S/N 28-23523N9977CSchuster Jacob M · Mchenry, ILBuilt 1972 · S/N 28-7225525N9977WN9977w LLC · Easley, SCS/N 28-23525N997NCVega Gustavo E · Watertown, NYBuilt 1965 · S/N 28-20817N9980WAll American Aviation Services Inc · Fayetteville, NCBuilt 1967 · S/N 28-23528N9984WBlake David R · Sheridan, WYBuilt 1967 · S/N 28-23532N9988WHanneman Michael W · Abilene, TXBuilt 1968 · S/N 28-24838N9989WDnr Solutions LLC · Idaho Falls, IDBuilt 1967 · S/N 28-23537N9993WTalon Aviation LLC · Greenville, MIFirst renewal noticeS/N 28-23542N999CLCollette Dean R · Effingham, ILBuilt 1970 · S/N 28-5829N99JMRebellion Point Aviation LLC · Elizabeth City, NCBuilt 1973 · S/N 28-7325611N99NCHrutkay Charles S · Scenery Hill, PABuilt 1968 · S/N 28-5044N99SWBurnette Preston B · Northport, ALBuilt 1966 · S/N 28-3585N9ALFly By Night LLC · Lexington Park, MDBuilt 1962 · S/N 28-581N9MEArtmann James · Zimmerman, MNBuilt 1967 · S/N 28-4380N9TARhynette Airways LLC · Key Largo, FLBuilt 1973 · S/N 28-7325541
Back to AD 96-10-01 R1