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.
N8298YEstes Bernard R · Bumpass, VAN8299PFischer Dale R · Laporte, INN82RJLynch James D Jr · Ocala, FLN8302YArnold Roger R · Jonesville, LAN8304YLusk Thomas L · Centennial, CON8309YHolman Michael J · Anchorage, AKN8310PPremiere Aviation Inc · Concord, CAN8311PDuckett Kristofer · Fairfield, CAN8311YAj Air LLC · Cape Girardeau, MON8313PSpencer Cory · Mobile, ALN8313YUnusual Attitudes LLC · Bates City, MON8315PSquawk Wv LLC · Morgantown, WVN8315YGolden Compass Aviation LLC · Wilmington, DEN8316PHolbrook James K · West Liberty, KYN8316YSchubnell Ryan A · Avondale Estates, GAN8318PPlane Old Memes LLC · Seminole, FLN831JRRegistration Pending · High Springs, FLRegistration pendingN8320PCallicrate Michael P · Saint Francis, KSN8320YKling Aviation Inc · Friendswood, TXN8322YDayhoff Miller Alice J · Springfield, OHN8324PCirrus Air LLC · Eden, NCN8324YStein Anthony J · Locust Grove, GAN8326YEastern Stearman Inc Trustee · Leesburg, VAN8327YKaeser Robert E · Lafayette, INN8328PSale Reported · Lewes, DESale reportedN8328YSims Chris · Colleyville, TXN8329YHarbock Inc · Wilmington, DEN8331PBurbanks Travis R · Tarzana, CAN8331YFeit Paul · Osprey, FLN8332PGray James Gary · Simpsonville, SCN8333PAllred Klein Enterprise LLC · San Diego, CAN8336PWyatt Gary D · Sun City West, AZN8336YPatterson Thomas A · Minerva, OHN8337YBorden William · Commerce Township, MIN8338PHerndon Properties LLC · Walterboro, SCN8339YBas Part Sales LLC · Greeley, CON833DFAirdorrin Inc · New Castle, DEN8340PChristiansen Lance W · Anacortes, WAN8341PLife Is Flying Inc · Deerfield Beach, FLN8341YPepper Dale D · Newnan, GAN8342PGibbs Randy Shane · Louisburg, NCN8343YSpector Steven D · Glenview, ILN8344PGulledge Richard · Deland, FLN8345PMcgough Christopher M Trustee · Hurricane, UTN8346PPhelps Michael J Trustee · Oneida, TNN8348PEchols Mark R · Diana, TXN8348YNelson Brian · Wakefield, NEN8349PPickett Douglas M · Romeo, MIN8351PComanche Air Holdings LLC · Austin, TXN8352YSkylandsair LLC · Port Orange, FL
Back to AD 82-23-01 R1