Registered aircraft · 176

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-13') 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-13') 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-13')
    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-13')
  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-13')
  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-13')
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.

N53MCGulf Air Aviation Inc · Wilmington, DEBuilt 1978 · S/N 31T-7820025 N53TAIndiana Paging Network Inc · La Porte, INBuilt 1978 · S/N 31T-7820083 N545RKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1977 · S/N 31T-7720064 N555FRWallace Jeffrey S · Bonita Springs, FLS/N 31T-8004010 N55RPneuma Aviation LLC · New Orleans, LABuilt 1976 · S/N 31T-7620055 N59EHSale Reported · Dawsonville, GASale reported, pending cancellationBuilt 1978 · S/N 31T7820014 N5DValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N 31T-7820080 N601AJShamrock Aviation LLC · Madison, MSBuilt 1984 · S/N 31T-1104013 N606DWElkhorn Valley Trucks II LLC · Fremont, NEBuilt 1981 · S/N 31T-8120038 N60JWTumbleweed Leasing LLC · Tacoma, WABuilt 1980 · S/N 31T-8004031 N6107AR & R Aviation Support LLC · Atlanta, GABuilt 1978 · S/N 31T-7820087 N611BT-2 Enterprises LLC · Walla Walla, WABuilt 1981 · S/N 31T-8166015 N6175ATiffin Aire Inc · Tiffin, OHBuilt 1979 · S/N 31T-7920011 N620DBAlco Plane Co LLC · Memphis, TNBuilt 1979 · S/N 31T-7920055 N621AKPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 31T1104014 N630MWDmp II LLC · Kissimmee, FLS/N 31T-8166011 N632CBIou Aviation Of Montana LLC · Sheridan, WYBuilt 1983 · S/N 31T8166066 N65BATts Leasing Inc · Kansas City, KSBuilt 1980 · S/N 31T-8020071 N66TWRolfe Bangerter Aviation LLC · Murray, UTS/N 31T-8004030 N67DWDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 31T-7620041 N68BJCrownair LLC · Mansfield, PABuilt 1979 · S/N 31T7920029 N700RDPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1985 · S/N 31T5575001 N708SAOlivier Seth Nicholas · Baskin, LABuilt 1981 · S/N 31T-8104042 N70GWAncient City Capital LLC · Saint Augustine, FLBuilt 1980 · S/N 31T-8104004 N70TWGunter Lennon DBA · Tabernacle, NJS/N 31T-7904043 N711ERCommunications Laboratories Inc · Melbourne, FLBuilt 1981 · S/N 31T-8104056 N723JPTiffin Aire Inc · Tiffin, OHBuilt 1978 · S/N 31T-7920009 N72JJCatton Consulting LLC · Fairfax Station, VABuilt 1980 · S/N 31T-8004048 N730PTTwin Otter International Ltd · Las Vegas, NVBuilt 1977 · S/N 31T-7720008 N731PBBeaver Creek Aviation LLC · Perry, IABuilt 1980 · S/N 31T8166001 N73BGRw Air Services Inc · Hatfield, PAS/N 31T-8004027 N770MGPlan Bee LLC · Washington, DCS/N 31T7520029 N774KVTjr Aviation LLC · Allentown, PABuilt 1982 · S/N 31T-8166057 N77NLNew South Inc · Charleston, SCBuilt 1977 · S/N 31T-7720038 N781CKSnowy Owl Aviation LLC · Charlottesville, VABuilt 1978 · S/N 31T-7820056 N7FLCentral Virginia Aviation Inc · Petersburg, VABuilt 1978 · S/N 31T-7820082 N7VRAja Aviation LLC · Hutchinson, MNBuilt 1978 · S/N 31T-7804010 N801HLKp Equipment Investments LLC · Cottonwood, AZBuilt 1979 · S/N 31T-8020016 N80MALsc Construction Inc · Perris, CAS/N 31T7720043 N818SFSierra Foxtrot LLC · Dodge City, KSBuilt 1980 · S/N 31T-8004018 N819SWWho Dey LLC · Savannah, GABuilt 1981 · S/N 31T-8104059 N81MSCapital Craft LLC · Wilmington, DES/N 31T-8104007 N824CBHelfrick Edward W Jr · Elysburg, PABuilt 1981 · S/N 31T-8104052 N827LPSagamore Aviation LLC · Lewes, DES/N 31T-7904048 N82XLFast Fly Inc · Dallas, TXBuilt 1981 · S/N 31T-8166034 N83CACheyenne 2 LLC · Colonial Heights, VABuilt 1980 · S/N 31T-8020072 N83MGWatkins Jon Trustee · Florence, ORBuilt 1981 · S/N 31T-8104047 N843DBDoan Creek LLC · Walla Walla, WABuilt 1978 · S/N 31T-7820090 N89JASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 31T7920030 N901TKAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 31T-7904028

Back to AD 96-10-13