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.
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
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.
N8483RWright Maurice R · Las Vegas, NVN8483WBrayman Aviation LLC · Hollister, MON8484RLegacy Aviation Group LLC · Orrstown, PAN8484WBoyett Alton M Jr · Waco, TXN8486CDown To Fly! LLC · Ocean Springs, MSN8486RBass Derrick Lamar · Semmes, ALN8486WBurke Richard A · Rock Port, MON8487WWilson Darrell III · Mcpherson, KSN8488RSugrue James E · Tampa, FLN8488WForbis Aviation LLC · Durant, OKN8489RPatriot Aircraft Leasing LLC · Erie, CON8489WColeman Greyson Edward · Byhalia, MSN8490RSimecek Glen D · Kirkland, WAN8491FRutherford Robert E · Maryville, TNN8491RDarnell Benjamin F Jr · Sevierville, TNN8491WMunson Justin M · Augusta, GAN8492WMoore Myron Keith · Amarillo, TXN8493RCapital City Flyers LLC · Thomasville, GAN8494RCactus Air Gold LLC · Mesa, AZN8495WSensenig Landis · Owen, WIN8496WKnapp Richard M · Dallas, TXN8497WAndrews James E Jr · Cantonment, FLN8498RLangeland Carrol · Menno, SDN8498WPetry Scott A · Greenfield, INN8499RZoss Curtis · Pensacola, FLN8499WNazif Ziad J · Denver, NCN8511FMrd Aero LLC · Manheim, PAN8515NCarolina Xl Aviation LLC · Fort Mill, SCN8543EAce Aircraft Leasing Inc · Nazareth, PAN8579NWillaero LLC · Union City, TNN8588BSavage James B · Gibsonia, PAN8592NSluder George L · Willard, NCN8594CNagia Omar Mohamed · Richmond, CAN8594NKosciusko Skipper N · West Cornwall, CTN8599NScott Lauren M · Lighthouse Point, FLN859TRaven Aviation LLC · Lexington, KYN85BKBkv Aero Squadron LLC · New Port Richey, FLN85WABeckwith James N · Goldsboro, NCN86028Caudle James Solomon · Greenville, SCN8605NTremper John D · Newton, NJN8609NBird Properties LLC · Roosevelt, UTN8619EHogan Daniel L · Chapel Hill, NCN8633EPompano Senior Squadron Flying Club Inc · Pompano Beach, FLN8649NManchester Thomas P · Wilmington, DEN8659EKuehn Ricky A · Mesa, AZN86ECParisi Mario · Grosse Ile, MIN8700NJones Jaycob Paul · Arlington, TXN8701NFuellner Frederick E · Shelocta, PAN8705NMay Randy S · Carrollton, TXN8712NCook Jeffery M · Lakewood, WA
Back to AD 96-10-01 R1