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.
N727PWSteven Bennett Trustee · Boise, IDN727SPinnacle Aviation Services LLC · Key Largo, FLN727SHCjt Cirrus LLC · Boston, MAN727SLRegistered aircraftN727SRMid-Way Regional 2023 LLC · Columbia Falls, MTN727VGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN727WSRobey Sean C · Camden, NCFirst renewal noticeN728United States Department Of Interior · Boise, IDN728BJBarefoot Boats LLC · Greensboro, GAN728CTBerns Ridge Service LLC · Whittier, CAN728DSTebeaux William Jene · College Station, TXN728SMMasters In Flight LLC · Friday Harbor, WAN728SRSouthside Tire Co Inc · Antigo, WIN728STV-Star Holdings LLC · West Lafayette, INN728TFLopez Noel · Mcallen, TXN729AJEdwards 729aj LLC · Dublin, OHN729BFox Air LLC · Canton, OHN729CDOmega Skyways LLC · North Bethesda, MDN729CWWright Matthew J · Bowling Green, OHN729JRJbj Air Services LLC · Virginia Beach, VAN729JWJ Dubb Air LLC · Cordele, GAN729KXShrago Daniel A · Springfield, VAN729LJArcher Matthew · Houston, TXN729MHAc Aircraft Holdings LLC · Dallas, TXN729MRFlanagan Brian F · Roseville, CAN729SASierra Alpha Leasing LLC · Naples, FLFirst renewal noticeN729TGKimbrell Todd Jr · Itasca, TXN729TXAcross America Aviation LLC · Moreno Valley, CAN729UMCuthbertson Air LLC · Apison, TNN729WMRiller David P · Bothell, WAN72ADMcguire Transportation LLC · Murfreesboro, TNN72BKUpper Airways LLC · Kalispell, MTN72CGGarvin Carroll E · Scottsdale, AZN72CUKuhlke K Lee · Englewood, CON72DFCirrus Design Corp · Knoxville, TNN72DTMalibu Aviation Inc · Wichita, KSN72DVStirling Motors LLC · Kalispell, MTN72EGM Group Aviation LLC · Medford, ORN72ETCirrwest Ltd · Grand Junction, CON72GGHall Joel · Nashville, TNN72JAOtter Air LLC · Fishers, INN72JESkyward LLC · Fort Smith, ARN72JVMatrix Commerce Solutions LLC · Point Pleasant Bch, NJN72KDN72kd LLC · Wilson, WYN72KGM & P Aviation LLC · Byhalia, MSN72KMIntrepid LLC · Helena, MTN72LEBarbee Mark E · Cody, WYN72LLKusy LLC · New Rochelle, NYN72LRSchnell Michael L · Spearman, TXN72MJValiair Lc Trustee · Casper, WY
Back to AD 2012-10-13