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.
N512UTFrank G Davis Holding Company LLC · Lakeway, TXN512XPilot Henry LLC · Big Prairie, OHN5130AAll Florida Aviation Inc · West Palm Beach, FLN5130YMerritt LLC · Leesburg, VAN5131QLeavitt Craig S · Spicewood, TXN5134CEzrydr LLC · Huntsville, ALN5134WPlane Fun Inc Tr Trustee · Snellville, GAN513CRN513cr LLC · Redondo Beach, CAN513DWright Aero Inc · Saint Cloud, MNN513DRSternhagen Richard · Sweetwater, TNN513JPMcbutler Aviation LLC · Hutto, TXN513PZSun Evergreen LLC · Lloyd Harbor, NYN513SROdan Aero LLC · Alpharetta, GAN513STAllensworth Timothy Lee · Bladenboro, NCN513TM7 Romeo Bravo LLC · Reno, NVN513TWGabriel Aviation LLC · Jacksonville, FLN513UCPoint Breeze Aviation LLC · Vlg Of Lakewd, ILN513WCayuga Aviation LLC · Ithaca, NYN513WCWk&H Ventures · Dorchester, NEN513XFarina Paul A · Liberty Twp, OHN513YZCenturion Aviation LLC · Appleton, WIN513ZPlain Nuts LLC · Dover, DEN513ZMBullard Aerospace Corp · Boston, MAN5140JTruk Err Inc · Wilmington, DEN5141QImagination Publications Inc DBA · Saratoga, WYN5144UAeronaut LLC · Saint George, UTN5147YN5147y LLC · Andover, MNN514BRJmb Aviation LLC · Iowa City, IAN514CCResa Group LLC · Brunswick, GAN514DTNorth Shore Aviation Inc · Merrick, NYN514EDFarris Stephen L · Hickory, NCN514HRSethi Inderdeep Singh · Tracy, CAN514LPInvader Aviation LLC · Tijeras, NMN514NCHyannis Air Service Inc · Hyannis, MAN514PZBig Red Aviation LLC · Truckee, CAN514RJDoin Blue LLC · Seneca, SCN514RTPanitz Law Group Apc · Cerritos, CAN514SGBorland Equipment Leasing LLC · Midland, TXN514SLPurple Wings LLC · Denver, CON514SMEleven Eleven Aviation LLC · Rockwall, TXN514SRHarbor Aviation Ltd · Camarillo, CAN5150B5150 Aviation LLC · Broken Arrow, OKN5150EM & M Aviation Enterprises LLC · Springfield, MON5151JHalverson Mechanical Inc · Ogden, UTN5151QNotsa LLC · Morrison, CON5154AA&J Air Sales Inc · San Antonio, TXN5156QN5156q Inc · Elmhurst, ILFirst renewal noticeN5156YCaprock Spraying Inc · Vega, TXN5159ADavis Nicholas R · Madera, CAN515BPBsport Enterprises LLC · Bonita Springs, FL
Back to AD 2012-10-13