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.
N8188YFly Anytime LLC · Kankakee, ILN818YInternational Air Services Inc Trustee · Carson City, NVN8191PN8191p LLC · Snowflake, AZN8192YPlane Fun Inc Tr Trustee · Snellville, GAN8193PFlying Crooner LLC · Orlando, FLN8194PMarrs Walter Scott · Chino, CAN8195PBoddington Aviation LLC · Portland, TXN8196PWorkman Randy · Tipp City, OHN8197YTyer Larry E Jr · Newnan, GAN8198YRoss Brian L · Eagle River, WIN81LLJma Aviation LLC · Lakin, KSN81MDTt Twins LLC · Fayetteville, GAN8200PSix Five Papa Inc · Temple, NHN8201YTorqmation Inc · Houston, TXN8203PDell John J · Saint Clair Shores, MIN8203YMn98 LLC · Belview, MNN8204YBlue Steele LLC · Barnegat, NJN8206PMente Charles E · Ocala, FLN8206YBauer Electric Inc · Winona, MNN8207YTwinkie Air LLC · Colville, WAN8208PGallacher Edwin T · Salt Lake City, UTN8208YAirswiss Inc · Wilmington, DEN8209PFox Black Enterprises Inc · Kilmarnock, VAN820TOneil John M · Leicester, NCFirst renewal noticeN8210PJohnson James E · Calhoun, LAN8211YMccoy Darren T · Caledonia, MIN8212PTweeddale Thomas Allan · Denton, TXN8213YBoomer Joshua G · Floyds Knobs, INN8215PAme LLC · Kalispell, MTN8215YGlassburn Teresa L · Winthrop, WAN8216YMedia Stew LLC · Carson City, NVN8217PDanilchuk Phillip A · Auburn, GAN8217YMaledy John Trustee · Salem, MON8219YDurden Julian F Jr · Twin City, GAN8220PParsell Scott · Katy, TXN8221PMoreau Donald G · Dayton, TXN8221YBill Kennedy Aviation LLC · Stuart, FLN8222PWeirich Joseph J · South Milwaukee, WIN8224YWoodard Earl G Jr · Danville, GAN8226YC P L Air LLC · Middletown, DEN8234YBurkey Jeffrey C · Stuart, FLN8235PZiesman Ernest D · Henderson, NVN8235YLyons Kenneth L · Port Neches, TXN8236PLeary Patrick W · Lewistown, MTN8237PNarveson Kristian · Pueblo West, CON8239P3so II LLC · Louisville, KYN8239YMurray Coy L · Guntersville, ALN8241PRegistered aircraftN8242PLake Donald T · Green Valley, AZFirst renewal noticeN8243PMountain Mooney Inc · Idaho Falls, ID
Back to AD 82-23-01 R1