AD 2012-10-52
Registered aircraft · 2,750
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:2012-10-52')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-52')
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:2012-10-52') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-52') 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.
N2265RHodhson Shell S · Wyocena, WIN2266SWeekend Air LLC · Incline Village, NVN2268BNitro Aviation LLC · Englewood, CON2269BAh1f Associates LLC · Clifton Park, NYN226GHTextron Aviation Inc · Wichita, KSN226MELawson Tim · San Clemente, CAN2271RLowe Vance E · Oakland Park, FLN2272DLucky Marmot Aviation LLC · Traverse City, MIN2272PSchmitz William M · Napa, CAN2272RBerntsen Kurt · Upland, CAN2279RLehmann Albert F II · Simpsonville, SCN2280RRusso John · Seaside, CAN2287RTail Winds To The Island Inc · Ashland, KYN228HSSweeney David H · Houston, TXN2292WA & L Enterprises LLC · Maiden Rock, WIN2295RDuhl James R · Roseville, MNFirst renewal noticeN2295WBraswell Jerrold W · Dillingham, AKN2296RCelias Food Corp · Miami, FLN2299RBaer Monte Wayne · Ronan, MTN22CHSupergo LLC · Menlo Park, CAN22CSClear Skies Aviation Enterprise LLC · Dover, DEN22EPRobinson Michael · Tucson, AZN22KMTorris Warren E · San Dimas, CAN2301QFarm West LLC · Missoula, MTN2306DUS Navy - Owner · Jacksonville, FLN230BLafitte John B · Villa Rica, GAN230BKErickson Bernard Rudolph · Saint Cloud, MNN230MAviation Developers Inc · Highlandville, MON230PLudian Malgorzata · Bakersfield, CAN2317GOrion Aviation LLC · Edmond, OKN2319SHotel Whiskey Aviation LLC · San Antonio, TXN23207Ttp Aviation LLC · Concord, NCN23215Bill Webb Construction Inc · Chico, CAN2326BRandigo LLC · Wilmington, DEN232MJNby Productions · Bristow, VAN232MTAir Force Life Cycle Management Center · Lexington, MAN232TJCsc Delaware Trust Co Trustee · Wilmington, DEN2340UTex-Pan Aviation Inc · Amarillo, TXN234HESchniederjan William Jason · Dalhart, TXN234WIwaa Inc · Woodstock, GAN23530Registration Pending · Grapevine, TXRegistration pendingN2353HBlackbird Enterprises LLC · Las Vegas, NVN235WJmzb Leasing LLC · Amarillo, TXN235WHTail Aero Corp · Wilmington, DEN2365FBottorff Jon C · Fishers, INN2365JBrosius Michael W · North Platte, NEN2370XSouthwest Aircraft Enterprises · Haslet, TXN2371HSan Jose Aviation LLC · Mission, TXN2375SLundin Lawrence D · Midvale, IDN23781Paragon Air Group · Fort Worth, TX
Back to AD 2012-10-52