AD 2012-10-13
Registered aircraft · 13,306
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-13')
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-13')
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-13') 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-13') 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.
N523CVA3k Aero LLC · Benton, KYN523DBN523db LLC · Santa Ana, CAN523DKCirrus Sr22t 9781 Inc Trustee · Wilmington, DEN523GWA And P Farms LLC · Wilmington, DEN523JTAircraft Partner Holdings Inc Trustee · BerlinN523JWOdyssey Aviation LLC · Kendall, KSN523KAKilo Alpha Aviation LLC · Chandler, AZN523KDBoatwright Jonathan · Austin, TXN523KMWoodland Robin · Hood River, ORN523MKRs2 Aero LLC · Birmingham, ALN523MPAerownership North American Services Inc Trustee · Wilmington, DEN523RCS W Air Travel Inc · Parshall, CON523RSN523rs LLC · Middletown, DEN523SHNesher Wings LLC · Phoenix, AZN523TBPenning Shawn P · Santa Fe, NMN523TVPer Analogiam Inc Trustee · Wilmington, DEN5244ZRobinson Levi B · Anchorage, AKN5249ABrentco Aerial Patrol Inc · Canton, OHN524CAHyannis Air Service Inc DBA · Hyannis, MAN524CBTechnical Film Systems Inc · Camarillo, CAN524CCAubuchon Scott M · Fenton, MIN524CMGracey Air LLC · Sandy Springs, GAN524DACpi Management Group LLC · Las Vegas, NVN524ESDickinson Drew H · New Braunfels, TXN524ETWanderair LLC · Maple Grove, MNN524JGHorlacher Robb · Stevensville, MTN524LLPremier Aviation LLC · Tucson, AZN524MMAviation Trust Company LLC Trustee · Oklahoma City, OKN524PEN524pe LLC · Brookshire, TXN524SBSlb Charter Services LLC · Saint Petersburg, FLN524SRWaypoint Holdings LLC · Greensboro, GAN5251CSherman Randolph · Beverly Hills, CAN5251JNarr Craig S · Fort Mohave, AZN5252ALong Harold M · Carson City, NVN5255CMcintosh Law Corp · Long Beach, CAFirst renewal noticeN5256JKamenz Donald R · Mocksville, NCN5258ABeta Aviation L L C · Lewes, DEN525BECya Aviation LLC · Saint Marys, WVN525ECJohn Papa Zulu LLC · Hauppauge, NYN525ELLennox Duncan M · Aptos, CAN525FSWrb Aircraft Leasing LLC · Wilmington, DEN525JRPj Flyer LLC · Avondale, AZN525KWFuller Thomas R · Scottsdale, AZN525PCJcp Logistics LLC · Little Rock, ARN525RRValiair Lc Trustee · Casper, WYN525SCM&M Flyboys LLC · Kalispell, MTN525SFPrimrose LLC · Columbus, NEN525SRSchnitker Air LLC · Kalispell, MTN525TMVertivue LLC · Allentown, PAN5260AN5260a LLC · Los Angeles, CA
Back to AD 2012-10-13