OpenAirDocs.org
AD 2019-08-13

Registered aircraft · 1,554

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:2019-08-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:2019-08-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.

N11SGOk3 Air Leasing LLC · Heber City, UTBuilt 2019 · S/N 525B0599N11THLipsey Leasing LLC · Newark, DEBuilt 2006 · S/N 525B0056N11VHRegistered aircraftBuilt 2025 · S/N 525B0745N11WBMercier David · Whitefish, MTBuilt 2006 · S/N 525-0616N1205Z198gb LLC · Asheboro, NCBuilt 2018 · S/N 525-0985N121DMMaisley Aviation LLC · Jasper, ORS/N 525B0500N121TSSky King Charters LLC · Cincinnati, OHBuilt 2023 · S/N 525B0692N121VMAlan Aviation LLC · Altadena, CAS/N 525-0314N1220WP2 Flight Operations LLC · Fort Worth, TXBuilt 2003 · S/N 525A0146N122ERAdvisors Aviation LLC · Saint Louis, MOBuilt 2005 · S/N 525B0030N122KHAirric LLC · Miromar Lakes, FLBuilt 2003 · S/N 525A0159N122PAPafford Medical Billing Services Inc · Hope, ARBuilt 2010 · S/N 525B0346N123CJElevation Air LLC · Miami, FLBuilt 2007 · S/N 525B0149N123CZOkay Inc Trustee · Wilmington, DEBuilt 2009 · S/N 525B0313N124BGAdvance Jets LLC · Cincinnati, OHBuilt 1999 · S/N 525-0345N124BLLofton Robert A · Brawley, CABuilt 2007 · S/N 525B0181N124HMiss Juliet LLC · Chatsworth, GABuilt 2002 · S/N 525A-0068N125BJQualitair LLC Trustee · MichelstadtS/N 525A0101N125CDAero Dynamic Medical LLC · Pleasant Grove, UTBuilt 2023 · S/N 525B0710N125DGFugal Aviation LLC · Pleasant Grove, UTBuilt 2006 · S/N 525B0060N125DWMcis Aviation LLC · Wilmington, DEBuilt 2021 · S/N 525-1095N125PLSutherland Lumber & Home Center Inc · Jenks, OKBuilt 2008 · S/N 525B0290N1277EHeaven Express LLC · Corralitos, CABuilt 2002 · S/N 525A0076N127FJFoxtrot Juliette Assets LLC · Newark, DEBuilt 2009 · S/N 525A0441N127MJZacj LLC · Zanesville, OHBuilt 1998 · S/N 525-0266N129DGDutra Group · San Rafael, CABuilt 2008 · S/N 525B0269N129TTTaun-Taun Transportation LLC · Healdsburg, CABuilt 2022 · S/N 525B0684N12GSBlue Sky Inc · Wilmington, DEBuilt 2006 · S/N 525B0122N12GYValiair Limited Co Trustee · Casper, WYBuilt 2000 · S/N 525-0374N12NSCbi Equipment LLC · Tualatin, ORS/N 525-1063N12RLPumpkin Patch Aviation LLC · Kodak, TNBuilt 2026 · S/N 525-1409N131MJEagle Aero Inc · Lafayette, LABuilt 2006 · S/N 525B0097N131PLPd Aero LLC · Oronogo, MOBuilt 1994 · S/N 525-0057N1327JAbsolute Altitude LLC · Bellefontaine, OHBuilt 1993 · S/N 525-0009N133GLHs Air LLC · Little Rock, ARBuilt 1993 · S/N 525-0001N137BGCroell Aviation LLC · New Hampton, IABuilt 2005 · S/N 525B0032N139CJAir Queso LLC · Harrison, OHBuilt 2007 · S/N 525B0139N13DCMarketing Strategy LLC · Missoula, MTBuilt 2022 · S/N 525B0677N13ECTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 525B0919N140DARamsey Hill Aviation LLC · River Falls, WIBuilt 2003 · S/N 525A0140N1414PWest Texas Pcs LLC · Los Ranchos, NMBuilt 2006 · S/N 525A0315N144ALB&K Leasing Company Inc · Big Bear Lake, CABuilt 2005 · S/N 525B0044N144YDZellair LLC · Wilmington, DEBuilt 2003 · S/N 525A0144N145CGPatrick & Brigitte Alias LLC · Fort Lauderdale, FLBuilt 2015 · S/N 525B-0480N146MMJackdaw Inc Trustee · Wilmington, DEBuilt 1997 · S/N 5250226N146SMTurbo Air Charter LLC · Boise, IDBuilt 2003 · S/N 525A0154N1482BClear Line Aviation LLC · St George, UTBuilt 2015 · S/N 525-0888N1482PBurcham Rentals Inc · Holts Summit, MOBuilt 2019 · S/N 525B0578N148FBTelum Air LLC · Sioux Falls, SDBuilt 2003 · S/N 525A0148N149WWCorsair Two LLC · Hillsboro, ORBuilt 2007 · S/N 525B0175
Back to AD 2019-08-13