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.
N307JHRoundy Joseph · Three Forks, MTN307RJGv Air Inc · Medford, ORN308AROverstreet Investments Inc · Boonville, MON308BCMike Kilo Foxtrot LLC · Wilmington, DEN308CPCivil Air Patrol · Maxwell Afb, ALN308DMD&M Aircraft Co Inc · Thonotosassa, FLN30942Polar Bear Aviation LLC · Batesville, MSN309DKNby Productions · Bristow, VAN30HDRegistered aircraftN30VGGeoterra Inc · Eugene, ORN30WLSkydive Coolidge Inc · Tempe, AZN311TGTg Air LLC · Fishers, INN312KKHowser Donald Marvin III · Granbury, TXN312SCBarker Family Investments Management Co LLC · Tyler, TXN313GBBurnett Gregory C · Rogersville, MON3148PSky Hi Aviation LLC · Wilmington, DEN314MEJfw Ranch Consulting LLC · Albuquerque, NMN3156XBack Country Aviation LLC · Jupiter, FLN3160LKo Hee Sun · Norwood, NJN316RWFour States Tire & Service Inc · Cortez, CON317MSHolley Melissa T · Baton Rouge, LAN319CSRas Airways LLC · Garland, TXN31SJCpc Aviation LLC · Algona, IAN321BPCenturion Air Inc · Ridgewood, NJN321LGLaughing Gull Aviation Inc · Fort Lauderdale, FLN321PCStene Aviation Inc · Polson, MTN322LKFindley Air LLC · Temecula, CAN32331Sowers Richard M · Reno, NVN323CPCivil Air Patrol · Maxwell Afb, ALN323DASky West Aviation Inc Trustee · Albuquerque, NMN323RTRoyal Blue LLC · Franklin, TNN324BKing Ag Leasing Inc · Sudan, TXN324MGSilver Eagle II LLC · Carson City, NVN324SMMaverick II LLC · Midvale, UTN325DDQuick Michael D · Middletown, CAN325LCCervantes-Galdeano Lorenzo · Ingalls, KSN3279NTips Frederick J III · San Antonio, TXN327BWCessna N327bw LLC · Telluride, CON327MTHayden LLC · Tiburon, CAN329CPCivil Air Patrol · Maxwell Afb, ALN329CSOvercast 329 LLC · Jonesboro, ARN32HSFarm Boy Aviation LLC · Boynton Beach, FLN32MCCook Tracy L · Prosper, TXN32MTHeading 406 LLC · Kalispell, MTN32PSDepartment Of The Interior · Boise, IDN33189Schrage Rodney L · Steamboat Springs, CON331CBN331cb LLC · Great Falls, MTN333BCMcfadden John L · Cresson, TXN333DAFavor Michael D · Chico, CAN333GKCenturion210 LLC · Amherst, NH
Back to AD 2012-10-52