AD 2012-24-09
Registered aircraft · 7,517
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-24-09')
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-24-09')
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-24-09') 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-24-09') 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.
N109FCUsda Forest Service Fepp · Tallahassee, FLN109MBFirefly Aviation LLC · Midland, TXN109RFBartley Scott C · Chaska, MNN10BGHemingway Donald S · Davidson, NCN10BNBlack Thomas D DBA · Clearwater, FLN10JKZalan Aviation LLC · Cincinnati, OHN10KGSeek Health Pllc · Naples, IDN10MAPatterson Casey Paul · Kinston, ALN10PBNeves Frank Jr · North Miami Beach, FLN10PJMiller Kenneth R · Russellville, KYN10QBAsc Aviation LLC · Brandon, MSN10YCToyz Aviation LLC · Worthington, KYN10YRAj Aviation LLC · Colby, KSN1103HSlezak David · Davison, MIN1106XVan Vleet Merlin D · Kingman, AZN1108PRay Lee LLC · Cody, WYN110AVCarter Jay W Jr · Wichita Falls, TXN110CARegistration Pending · Sturgis, SDRegistration pendingN110GGSkyview Aviation LLC · Tracy, CAN110MJTuggle Jason C · Liberty Hill, TXN110PAPostupack Peter Jr · New Cumberland, PAN110RVMillspaugh John · Weatherford, OKN110STBright Dale A · Limestone, TNN110WBFerrin Aviation LLC · Rome, GAN11111Star Flight LLC · Bellevue, WAN1111MRw Air LLC · Rock Hill, SCN111CFGsm Tax & Insurance Inc · Naples, FLN111DLCresence LLC · Port Saint Lucie, FLN111DVSouthern Aircraft Consultancy Inc Trustee · Casper, WYN111EWimpy Scott · Griffin, GAN111GAGeorges Aviation Services Inc · Honolulu, HIN111LFZimmerman Leland · Center, CON111PHGood Flight Aviation LLC · Stockton, CAN111PKScruggs Ken · Galloway, OHN111RXThompson William · Tampa, FLN111SEKeith Fischer · Gig Harbor, WAN111SMMuller Aviation LLC · New Baltimore, MIN111SNHalbert Kevin · Tyler, TXN111SXJcccs Land And Cattle LLC · Harrisburg, NEN111UCRcht LLC · Mason, OHN111WYN111wy LLC · Wilmington, DEN1122EVasey Igor · San Francisco, CAN1125GBlue Knot LLC · Teguesta, FLN112AANestor Richard · Portsmouth, NHN112HDJackson Larry D · Orlando, FLN112RMAppalachian Aviation LLC · Harrisonburg, VAN1131QFarm Country Air LLC · Jefferson, IAN1139LMathewson Crews Aviation LLC · Indianapolis, INN1139ZGonet John Charles · Southwick, MAN113BPSouthern Aircraft Consultancy Inc Trustee · Casper, WY
Back to AD 2012-24-09