AD 82-23-01 R1
Registered aircraft · 3,118
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:82-23-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:82-23-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:82-23-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:82-23-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.
N7159PAdams George D · Franklin, INFirst renewal noticeN7159YPepmiller Scott C · Panama City Beach, FLN7161PMaurer Bruce C · Power, MTN7163YBoyd John W · Milton, WAN7164YGreat Lakes Air Ventures LLC · Mason, MIN7166YCollum Aviation LLC · Milton, FLN7167YThomas Thomas J · Lewisburg, WVN7168PSchober Brian S · Scottsdale, AZN7170PDalton Dennis P · Walsenburg, CON7171YHeinrich Steven W · Conroe, TXN7172PBarksdale Kevin L · Moore, OKN7175PNewton Roger N Jr · Marerro, LAN7177POverstreet Robert S · Clarksville, VAN7178PN9271p LLC · Pahrump, NVN7179PHedgpeth H Brent · Bothell, WAN717TATwin C Aviation Inc · Chapel Hill, NCN7180P352 Aviation LLC · Clermont, FLN7180YAl-Banna Emad R · Huntingtown, MDN7181PStrydom Cornelis F · Liberal, KSN7182YMccue John M · Tuttle, OKN7183KRabourn John P · Spokane, WAN7184PWilson Brian E · Lecanto, FLN7185PMack Darryl T · Matteson, ILN7186YHill Mark T · Gloucester, VAN7187YAircore LLC · Apache Junction, AZN7188PBackcourse Flyers Inc · Powell, TNN7188YRegistration Pending · Christiansted, VIRegistration pendingN7189PTofan Ray · National City, CAN7189YHesano Joseph M · Rockford, ILN718JRFlytwincos LLC · Las Vegas, NVN7190YMiller Kevin · Collegedale, TNN7191PRamineni Raja · Fort Mill, SCN7192PBest Equipment Leasing LLC · Bakersfield, CAN7193PSzczawinski Anthony J · Elko, NVFirst renewal noticeN7196YAircraft & Aviation Professionals LLC · Coldwater, MIN7199PLee Jeffrey L · Cameron, MTN7199YFour Way Aircraft Ltd · Pensacola, FLN71ADSons Aviation LLC · Moody, ALN71BBMitchell Trans · Timnath, COFirst renewal noticeN71GMEtheredge Mark · Pell City, ALN71GTHazduff LLC · Plainfield, INN71PVCeleste LLC · Playa Del Rey, CAN7200PThompson Grover A · Locust, NCN7200YBroussard Don W Jr · Wynne, ARN7203PGorge Fast Aviation LLC · Hood River, ORN7204PPittner Hans C · Goshen, NYN7206YSkyflite LLC · Hillsboro, ORN7207PSteinbach Philipp · Bentonville, ARN7209YThy Will Be Done Here LLC · Reno, NVN7210PBirdwell David W · Richmond, TX
Back to AD 82-23-01 R1